Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS - Using a server variable within execute sql task code RE: SSIS - Using a server variable within execute sql task code
Chris Hurlbut
SSCarpal Tunnel
Points: 4162
More actions
November 23, 2010 at 6:13 am
#1254390
My vote is with Da-Zero. Dynamic SQL in Execute SQL tasks. I think these run more efficiently than Data Flow tasks, especially if you will be working with big record sets.