Build dynamic SQL statement

 Build dynamic SQL statement
 Expression on the SQLStatementSource property of Execute SQL Task:

"SELECT Column From " + @[User::TableName] +WHERE DateFilterColumn = '" + (DT_WSTR,4)YEAR(@[User::DateTimeVar]) +
RIGHT("0" + (DT_WSTR,2)MONTH(@[User::DateTimeVar]),2) + RIGHT("0" + (DT_WSTR,2)DAY(@[User::DateTimeVar]),2) + "'"
Expression Output:SELECT Column FROM MyTable WHERE DateFilerColumn = '20060915'