CODEWITHSUNDEEP
ssis
Doug Dawson
Doug Dawson

Reputation: 1273

Can I use SQL on the output of a Merge Join?

I'm using SSIS to fetch data from two Informix servers. I'm using a Merge Join object to combine the data together. Now, I need to summarize the data for reporting.

I worked up the T-SQL for pivoting, counting and summing the data I want, but I don't know how to do that in SSIS. I just want to run a query against the output of the Merge Join. How do I do that?

The pivot object looks too simplex for the job.

Thanks!

Upvotes: 1

Views: 623

Answers (2)

Patrick Kelly
Patrick Kelly

Reputation: 33

I would try sending the results of your data flow task to a object-typed variable. I believe you can manipulate the data directly in memory rather than dumping it to disk.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

Upvotes: 0

HLGEM
HLGEM

Reputation: 96552

I'd suggest that you insert the product of the merge join to a staging table and finish off the dataflow that way. Then start a new data flow with your t-sql code (referencing the staging table) as the source and then run it directly into the destination.

Upvotes: 3

Related Questions