Pass data between two data flow tasks

Hi Guys,

I have yet another question. How can i pass data b/w 2 data flow tasks? I'm trying to get some data from one sql server and then I want to pass this whole bunch of data to another data flow task which is going to get some data from second sql server. I would probably combine them using union all and then save that as a transaction in a third sql server?

Information regarding how to pass the data with some detailed discussion would be fine with me.

thanks

Gemma

Would the Merge Join transformation work for you? You could just have two sources within a single DataFlow Task and then merge their outputs.|||

Hi karfast,

Thank you for your response. Yes you're right but how would i put a new column when i'm saving the data?

Gemma

|||

Add a derived column / lookup column / join column... It depends on what you want in the new column.

For example if you want to add a timestamp you could just throw in a current timestamp from a derived column. If you want to add in information based off of a key in your original data you would use a lookup transform and input the column based off of the foreign key. etc....

Hope this helps.

|||

Gemma wrote:

Hi Guys,

I have yet another question. How can i pass data b/w 2 data flow tasks?

Probably not relevant anymore but the answer to your original question is "Use raw files".

Raw file information

(http://blogs.conchango.com/tags/SSIS/raw+files/default.aspx)

-Jamie