March 15, 2011 at 3:32 am
I created one package which is exporting the data from table to flat file destnation. If I want to use the same package for exporting the data from different table to Flat file. But its giving error and how can i approach for these requirement?
March 15, 2011 at 6:40 am
Are you trying to export from two different tables to two different flat files? Or from two tables to one flat file? Or are you trying to get it to choose a table based on something and then export that? I can't tell from your post.
- 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
March 15, 2011 at 8:02 am
1. I have Three different Structure of tables at source end.
2. I need a flat file from every table.(seperately)
3. I want write one package to satisfy all of the above.
example:
1.Type 12 table --- source to Type12 file -- destination
2.Type 13 table --- source to Type 13 file --- destination
3.Type 23 table --- source to Type 23 file --- destination
i run package for getting one flat file for one time.
instead of 3 packages i want one package to fullfill the above
thanks,
rak
March 15, 2011 at 8:16 am
The easiest (as I understand your requirements) is to have a single package with 3 data-flows, one for each file. Or you could have 1 data-flow to handle all three. Either way you have at minimum a flat-file souce for each file and a destination. So 6 components in a data-flow.
If you wanted one data-flow to handle the three different files since they have 3 different structures that really isn't possible out of the box. The thing to remember is that the metadata such as pipeline items and datatypes cannot change at run-time.
CEWII
March 16, 2011 at 8:17 am
I would do three data flow objects in one package for that. Easier to document that way. They can be set to run in parallel or in sequence, whichever works best for you.
- 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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply