June 11, 2003 at 3:39 pm
I am trying to use DTS to import data from text files created by DB2 v5 EXPORT utility. The columns are comma delimited, text is in double qoutes, and row delimiter is a CR/LF. Some of the files have NULL values as the last column value; when I use DTS it does not pick up the last column, although a data column is there it's just NULL. Any ideas as to why or how to force DTS to recognize the last column with NULL values?
June 16, 2003 at 8:00 am
This was removed by the editor as SPAM
June 16, 2003 at 9:01 am
Make sure the first row has a value in that column. DTS seems to use the first row to generate the structure and if doesn't have some value, then all data in that column will be ignored.
You might also create the table first and use DTS to insert the data into your structure. I don't know if that will be available to you or not.
Michelle
Michelle
June 16, 2003 at 1:23 pm
I concur w/mimorr - add a value to the end of the first row of the text file to cause DTS to recognize the correct # of columns.
I have a similar situation and simply add empty strings to make the first row have the correct # of columns.
Bill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply