- Posts: 7
- Thank you received: 4
Export from SQL table missing data in one column
2 years 2 months ago #21203
by billq23
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.
Any idea why this is happening and how can I fix it.
Please Log in or Create an account to join the conversation.
2 years 2 months ago #21205
by admin
Mike
ETL Architect
Replied by admin on topic Export from SQL table missing data in one column
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
2 years 2 months ago #21207
by billq23
Replied by billq23 on topic Export from SQL table missing data in one column
That worked! Thank you.
Please Log in or Create an account to join the conversation.