Post reply

SSIS Package for multiple files with multiple destination

  • May 24, 2016 at 10:27 am

    #400197

    four files are dropped in a directory every morning - 2 files are copied to SharePoint list 1, 3rd file to sharepoint list 2 and 4th file to sharepoint list 4. how do i achieve this using ssis package. i was planning to write 3 separate packages as destinations are different. i dont think i can use foreach loop either. Any thoughts?

  • May 25, 2016 at 2:54 pm

    #1881460

    You can have multiple connection managers and data flows in the package.

    So in this case you have 4 connections - the source and the 3 targets.

    Create 4 data flows and you're good.

    Is there a business reason why you can't write it this way?

  • May 25, 2016 at 3:05 pm

    #1881463

    Thanks for the reply, After the data flow task i'll be moving all files to a different location after renaming it. SO i was planning to do a single foreach loop for all files. will that work?

    Are 4 data flows in sequence order?

  • June 7, 2016 at 3:20 pm

    #1883741

    Sorry - didn't see you had more questions. :ermm:

    You can put each data flow and file move into its own sequence container and add your precedence constraints so they happen sequentially as desired.

  • June 7, 2016 at 3:51 pm

    #1883746

    Thanks for your reply 🙂 . So to make sure i understand it clearly - i have to use 4 file task with 4 data flows and put them each in a sequence container?

  • June 14, 2016 at 12:21 pm

    #1884996

    Correct. Sequence containers are great for this kind of thing. It keeps your code steps together and you can create a control flow as needed.

Viewing 6 posts - 1 through 5 (of 5 total)

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