Iam starting new in DTS . My task is to parse a text file and store into SQL Server Database. Iam using a file connection , but ran into a problem when specifying the columns. I am not able to specify columns past position 45 ! I see a red vertical line at pos 45 in the 'Fixed Width Column' window. How can i go past this red line to specify more columns? I would appreicate help from DTS Gurus on this forum.
Have you designed the table before specifying the text file to parse? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
