Home Forums SQL Server 2005 SQL Server 2005 Integration Services Sql command not taking the packagevariable value RE: Sql command not taking the packagevariable value
Phil Parkin
SSC Guru
Points: 247210
More actions
July 6, 2009 at 6:36 am
#1020316
OK, not quite correct for an OLEDB source.
First you need to assign the whole SQL string to a variable, then you need to change the Data Access Mode on your OLEDB source to be SQL Command from variable - the rest is obvious, I think.
Phil