dbTalk Databases Forums  

Column lines missing in text import

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Column lines missing in text import in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rfh
 
Posts: n/a

Default 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?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.