Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 My source file is a fixed width text file and...

Author  Topic 

ahouse
Starting Member

27 Posts

Posted - 2008-05-07 : 12:08:04
I am establishing the columns for a fixed width text file in my DTS package. The fixed width file contains 7700 characters per line. I have been setting column markers with no problems until I get to about character 3,620 and then it simply will not create any more markers. If I keep trying to click to make the marker it eventually scrolls me back to around character 200. I thought I had possibly used too many markers but after removing some of the other ones, I still could not create any more.

Are there any known restrictions for doing something like this? I'm stumped!

ahouse
Starting Member

27 Posts

Posted - 2008-05-07 : 12:13:49
More specifically, character 3640 is the last one I can add something to. If I try to add one there and drag it to the right, it takes me back to character 1.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-07 : 14:43:51
What's data type of the column in sql table?
Go to Top of Page
   

- Advertisement -