Execute SQL vs. DataContainer

[developer155]

Hi, what is the difference between the ExecuteSQL task and DataContainer. Looks like both can execute SQL statement and return results into a variable.
What I need to do in my ssis is to execute a bunch of different SQL statements and sp's and pass output data from one to another. The statements will be executed on different servers.
What is the best way to do this? Use a bunch of ExecuteSQL tasks and create a bunch of variables? I cannto find a good tutorial where it shows how to extract some data from one SQL table and pass it to another SQL call. All I see is flat files, etc. Any tips would be really appreciated

thanks

 

[manmaria]

Datacontainer is useful when your destination on dataflow is recordset or rowcount etc.,

If you want to pass variables from one sql statement/sp to another then you have to run then in sequence to receive the variables. It all depends on what is going on SP.

HTH

 

[Catadmin]

I don't see DataContainer on my Toolbox list and I'd like to look at it. Where is it located?

Thanks,


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"