DTS File Connection | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS File Connection

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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.