I am unsure if this is a matter of opinion or if there is actually a logical explanaition... so here we go: Someone at my work advised me that I should have created a temporary table before exporting data from one server to another remote server rather than using anSSIS package with a OLEDB Source and OLEDB Destination components in order to conserve server resources. Here are the details: I need to extract data from one server (joining to two lookup tables on the same server and database) and write them to another, remote, server. The table I am querying has 50+ million rows and my query will return approx 5 million rows of data. I used SSIS to do this utilizing OLEDB Source (with the appropriate SQL code) and OLEDB Destination to get the job done. In my opionion, creating a temporary table would have not save any server resources since I would have added an additional step and writing to a table (in this case the temporary one) would have occupied even more server resources. Am I missing something and being wrong? If so, what am I missing? Thank you in advance!

Hello, Seems like you are on right track, Writing to temp table and then query temp table will take more time as you explained yourself. Second why to add an extra step, if we can extract data directly. My vote goes to you! Thanks

I am agree with you and Aamir, using temp table has nothing to raise performance in this case. go on your way to transfer data in SSIS directly.http://www.rad.pasfu.com

I am agree with you and Aamir, using temp table has nothing to raise performance in this case. go on your way to transfer data in SSIS directly.http://www.rad.pasfu.com

I am agree with you and Aamir, using temp table has nothing to raise performance in this case. go on your way to transfer data in SSIS directly.http://www.rad.pasfu.com