Export from SQL table missing data in one column

  • Posts: 2
  • Thank you received: 0

Export from SQL table missing data in one column was created by billq23

When exporting from a MS SQL server view to a comma delimited file, one of the columns contains no data in the output file. While the column can be quite I have limited the length to five characters and the data still does not show in the output. If I hard code a value in the column it works. No errors show in the log and it processes all of the other columns fine.

Any idea why this is happening and how can I fix it.
3 weeks 5 days ago #21203

Please Log in or Create an account to join the conversation.

  • Posts: 8266
  • Karma: 33
  • Thank you received: 539

Replied by admin on topic Export from SQL table missing data in one column

Please have a look at this wiki article

www.etl-tools.com/wiki/knowledgebase/blob_field_is_empty
Mike
ETL Architect
3 weeks 5 days ago #21205

Please Log in or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0

Replied by billq23 on topic Export from SQL table missing data in one column

That worked! Thank you.
3 weeks 5 days ago #21207

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies