Dynamically decide the table name in execute sql task for create table
statement
I want to know if this is possible to do in SSIS Execute SQL task. I want
to check for existence of a table and if not existing create a table. I
want to keep the Table name in a variable so I can execute the task
against different databases and be able to change the tablename.
As an example I have this code: if not exists (select * from sysobjects
where name='Table1' and xtype='U') Create Table Table1( Col11 varchar(10)
primary key, Col12 varchar(10) );
For Flexibility I want to store the value Table1 in a variable and keep
changing it to create different tables each time I run the package.
No comments:
Post a Comment