How to read only particular fields from flat file into the database in ssis

  • Hi,

    I have one flat file having number of columns(45) in that i have to filter the columns i.e, 10 columns from each row by using the condition and have to store it in the database.

    ex: flat file having 100 rows in that i have to find 3rd column value which is 3 then after that row i have to move the data into seperate file which is belongs to the type 3. It means type 3 data will be stored in one flat file till the end of that type, after that i will verify again another type viceversa.

  • OK, so ... what is your question?

    A couple of lines of sample data will probably help people picture what you are trying to do.


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

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