SSIS creating new table on different server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS creating new table on different server

I’m trying to create an SSIS package that will drop a table if it exists on server B(destination), then copy the table from server A(source) to server B (new table on B) and build the index. Steps in Package –
Step 1 – Exec SQL Task to drop the table if it exists. Step 2 – Data Flow task that copies the table from server A to B. The table is a New table on server B so I click New in the "Name of the table or the view:" and change the SQL to have my table name and click ok. Step 3 – Exec SQL Task to build index. QUESTION – Why do I have to update the SQL in step 2 with my table name every time I run the package? If I don’t update it I get an error message saying "Invalid object name ‘my table’". Andy
May be you are dropping the object but not creating. Mohammed U.
]]>