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.

  • July 10, 2013 at 12:32 pm

    #1631354

    Yes, there is fix number of column, but as you suggest in Case1. How do I seperate cause just looking file name I do not know the number of column. If I would know number of column by looking file name then as you said I could do.

    As you said in case2, no there is no distinct file name base on column name.