September 8, 2011 at 11:16 am
Hi All,
I have around 50 tables, containing thousands of rows. I want to create a SSIS package, which can move all my data in all the tables in one time. Right now, I have to create a package for each table, but that is very time consuming. Can anyone suggest me about creating multiple data flow tasks in one package?
Thanks
V
September 8, 2011 at 11:20 am
Are you creating the package in BIDS or some other interface? Multiple data flow tasks in BIDS is dead easy, just drag and drop them onto the workflow.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 8, 2011 at 11:27 am
Yes, I am using BIDS..
I have an execute SQL task and it is connected to a data flow task (Control Flow). Then, in the data flow, I am trying to add all the sources and destinations (sources are connected to destinations only), But, I am getting an error always. This thing is working only when I have only one data flow item in the data flow.
What am I doing wrong? Do I need to have different data flows in the control flow?
September 8, 2011 at 11:54 am
No, I've had multiple data flows in one data flow task.
What error are you getting?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 8, 2011 at 11:58 am
I am getting the following error:
there is already an open dataReader associated with this command which must be closed first.
Do I need to connect the data flows with each other using any tool box feature.
How do I place the different tasks in one data flow? I tried many things, but nothing worked out for me.
thanks for your help and time.
Regards
V
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply