SSIS Task

Question

SSIS Task

Sachin4all

Ten Centuries

Points: 1249
More actions
June 12, 2011 at 7:39 pm

#237722

Hello
I have a stored procedure which generates data in a temp table..This same SP is run on 4 different databases parallel.The 4 temp tables data should be merged and should generate a CSV File .Can anyone help me on this.
This should be done in SSIS

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

raghukankanala (6/12/2011)
Hello
I have a stored procedure which generates data in a temp table..This same SP is run on 4 different databases parallel.The 4 temp tables data should be merged and should generate a CSV File .Can anyone help me on this.
This should be done in SSIS

Are you creating a Global Temp Table or what?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sachin4all Ten Centuries Points: 1249 More actions · Answer 2

Sachin4all

Ten Centuries

Points: 1249

June 12, 2011 at 9:45 pm

#1337556

It's a database Table

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

You need to define a connection to each table in each database.

You should append the results to the csv file.

Why do you want to execute this in parallel?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sachin4all Ten Centuries Points: 1249 More actions · Answer 4

Thanks

Those should be run parallel because of time constraints.

The stored procedure generates same type of meta data in each database.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Then you probably want to write in parallel to a table and then out to the csv file.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sachin4all Ten Centuries Points: 1249 More actions · Answer 6

Hello

what i am planing to do based on your suggestion is to load the data which comes from each SP to a table in the same DB on which the SP is running.

Then a DF task which has 3 OLEDB sources pointing to the 3 tables in respective DB then use a union all to merge the data.

Thanks for the help Welsh.I figured out this based on your suggestion

Let me try this one