akin.akinwumi (6/15/2012)
Copy your linked server query into an 'Execute SQL' task in SSIS. That way you get the best of both worlds!;-)
In my opinion that is actually the worst of both worlds. You're bypassing the valuable functionality built into SSIS for data movement while still allowing SQL Server to SQL Server communication. Sorry, but it is hard to imagine a worse decision being made in this scenario :sick:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato