Column lines missing in text import -
05-26-2006
, 03:15 PM
I have a number of DTS packages that have been used for years. Today I needed
to add a new column to a text file that is imported into a table. When I
opened the text file connection and selected "Properties", I saw "Fixed
field" was selected and data from the text file was displayed. When I clicked
"Next" the data was displayed and I expected to see the column separator
lines defining the individual columns in the data. There are no lines.
When I click on the Transform Data task, there are the correct mappings
between the columns in the text and the columns in the table.
I checked 8-10 of the other packages we use every day and most had the
column separator lines, but a few did not. I've never seen this before. Is
there any way to recover the column separators or do I just have to re-enter
them all. This particular text file has several hundred columns. Any idea why
they would disappear? |