I need to modify the preparation sql task built by the import wizard. I wanted to create an expression using the create table sql but insert the variable to append the date and another descriptor to make it dynamic. The source is Excel
The expression would look something like this
"Create Table" + @user::descriptor + @user::todaysdate+" ( name varchar(50) ..........."
SSIS cannot evaluate the sql although it runs fine in ssms
The column mappings will always be the same but the table name needs to be dynamic
View Complete Post