SQL Server Performance

DTS File Connection

Discussion in 'SQL Server DTS-Related Questions' started by rhegde, Feb 7, 2005.

  1. rhegde New Member

    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.
  2. satya Moderator

    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.

Share This Page