SQL Server Performance Forum – Threads Archive
DTS File ConnectionIam 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.