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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>