March 30, 2012 at 12:08 pm
We have a ssis package that has about 80 data flows tasks in it. It was created by a contractor who has left us.
They are all data flows that import data from flat files from one directory to a same database .
From what I see in BIDs, it doesn't look like each task is created individually, they all look the same format, I think they are generated somehow by batch, but I don't know how?
Any ideas?
Thanks
March 30, 2012 at 12:23 pm
Probably not a batch process...more likely copy/paste. You can copy Data Flow tasks, and then paste them back to the same Control Flow surface to gain a complete copy. If they are all very similar, that was likely the approach to get to count up to 80.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 30, 2012 at 12:38 pm
Thanks a lot
April 1, 2012 at 11:42 pm
Or the import/export wizard was used.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 2, 2012 at 12:29 am
Koen Verbeeck (4/1/2012)
Or the import/export wizard was used.
I did not know you could use the I/E Wizard to create more than one Data Flow task in a single package.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:31 am
Well, the wizard will create multiple dataflows if you import a lot of sources.
I believe the wizard puts around 5 sources in one dataflow, and then creates a new one.
I once imported 60 tables from Oracle, so that gave me about 12 dataflows, all of them looked very similar of course.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 2, 2012 at 12:34 am
OK, tables, yes, I was aware that you could select more than one table in the wizard but the OP was asking about flat files.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:39 am
opc.three (4/2/2012)
OK, tables, yes, I was aware that you could select more than one table in the wizard but the OP was asking about flat files.
You're right.
This makes copy/paste a more likely scenario 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply