Export from SQL table missing data in one column

More
2 years 2 months ago #21203 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.

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

More
2 years 2 months ago #21205 by admin
Please have a look at this wiki article

www.etl-tools.com/wiki/knowledgebase/blob_field_is_empty

Mike
ETL Architect

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

More
2 years 2 months ago #21207 by billq23
That worked! Thank you.

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