Home Forums Data Warehousing Integration Services variable column count txt files to sql server table RE: variable column count txt files to sql server table

  • February 22, 2011 at 1:01 pm

    #1290058

    I would use SSIS to store the CSV list into a staging table with a single column.

    Then I would call a sproc with a fast split string function (e.g. DelimitedSplit8K) and a CrossTab query to get the data back in one row, filling the missing volumns with zero at the same time. Finally, the sproc would be used to insert the data into the final table.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]