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

Share This Page