SSIS Package for multiple files with multiple destination

Question

Post reply

SSIS Package for multiple files with multiple destination

uzn2010

Ten Centuries

Points: 1369
More actions
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?

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

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

JustMarie SSCertifiable Points: 7771 More actions · Answer 1

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?

uzn2010 Ten Centuries Points: 1369 More actions · Answer 2

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?

JustMarie SSCertifiable Points: 7771 More actions · Answer 3

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.

uzn2010 Ten Centuries Points: 1369 More actions · Answer 4

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?

JustMarie SSCertifiable Points: 7771 More actions · Answer 5

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.