SSIS Data Transform

• S7

  Mr or Mrs. 500

  Points: 577

  More actions

  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.

• Todd McDermid

  Default port

  Points: 1416

  More actions

  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