September 20, 2012 at 12:30 pm
Is there a way to generate multiple data flow tasks?
We need to import data from 40 flat files to 40 SQL server tables, instead of manually create each data flow task manually one by one, is there a way to generate multiple data flow tasks?
Thanks
September 20, 2012 at 1:04 pm
sqlfriends (9/20/2012)
Is there a way to generate multiple data flow tasks?We need to import data from 40 flat files to 40 SQL server tables, instead of manually create each data flow task manually one by one, is there a way to generate multiple data flow tasks?
Thanks
As far as I know, nothing that is less complex than just doing the work in the first place. You'd have to build out the XML that drives the package along with detecting flat file information, schema data, etc.
If you find something simple please post back, but anything I've seen has been more of a 'hm, that's interesting' than 'oh, I could use that'. The resultant complexity pretty much makes it non-portable outside of the original creator because of the billion little tweaks that result.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2012 at 1:32 pm
The reason I ask is I saw actually we have a ETL that seems generated somehow.
In it there are about 30 data flows, from the format they look so alike.
They intitially were created by a consultant developer that has left
I just heard from another developer says it looks like they are generated somehow using .net or visual studio.
September 20, 2012 at 1:39 pm
sqlfriends (9/20/2012)
The reason I ask is I saw actually we have a ETL that seems generated somehow.In it there are about 30 data flows, from the format they look so alike.
They intitially were created by a consultant developer that has left
I just heard from another developer says it looks like they are generated somehow using .net or visual studio.
Or copy/paste/edit, which is how I usually do mine when I start getting into packages with that many simultaneous updates.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2012 at 1:47 pm
You may be right, thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply