Home Forums Data Warehousing Integration Services Load in different table base on different number of columns in text file. RE: Load in different table base on different number of columns in text file.

  • Thanks for your help.

    I am very close as you suggest last time.

    I did use for each loop and load all data in one table which have one column.

    In T-sql, I count number of , (comma delimitar) and load in 3 respective tables.

    To grab, those individual value, I used charindex and substring and finally load in right table.