Post reply

flat file and sql table

  • July 23, 2009 at 8:11 am

    #140166

    i am creating an package where i have to dump a flat file to sql table.

    the flat file might contain millions of records but i want to filter only those records based on certain conditions.

    for example:

    Department table has 10 department

    Employee table which will be from the flat file has 10000 records for each department (say 10000 * 10 times) but i am interested only in 2 or 3 departments present in the flat file which means 10000 * 2 or 3 times

    How do you do it in SSIS?

  • July 23, 2009 at 8:23 am

    #1028986

    Use the Conditional Split in the data flow to filter out the records. Direct the ones you want to your table. Ignore the others.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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