July 1, 2014 at 10:57 am
Is it possible to connect two different control flow together.
For example I have a control flow that is linked to a data flow that will generate some PDF files the same for XML files.
What I want to do is join the two control flow that will lead to one data flow with both information. then to run the package as one so I can schedule it as one job.
Also, not sure where this can go but I want to execute a sql statement once the pdf and xlm data flow is complete. The SQL statement execution is to flag the PDF in a table. The script is already done just don't know how to add it in the package to execute it.
Thanks
Kevin
July 1, 2014 at 1:12 pm
I'm not sure I completely understand what you are trying to achieve.
Normally you should be able to do everything in one single control flow.
You can have multiple data flows (one for PDF and one for XML?) and you can connect both data flows to an Excecute SQL Task.
This task will execute once the two data flows have executed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2014 at 8:17 am
Thanks Koen it worked. I was not sure if I was able to connect the different control flow. Thought I would get some type of error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply