Post reply

SSIS Data Transform

  • March 31, 2011 at 1:23 pm

    #236178

    Can someone let me know how I could possibly convert raw text file to SQL table? I tried SSIS Data flow from flat file to the OLE DB but there is not comma and the file is huge. Do you know how I could separate the columns? Please let me know. Thanks.

  • March 31, 2011 at 3:58 pm

    #1306235

    SSIS can import fixed-width flat files as well - is that your file format?

    Please describe how your flat file is organized - how can you tell where one field ends and another begins? How do you know when you've reached the end of a row? Do all rows have the same number of fields?

    Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
    My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply