SQL Server Performance

SSIS creating new table on different server

Discussion in 'SQL Server 2005 Integration Services' started by andyrussell_10, Nov 15, 2006.

  1. andyrussell_10 New Member

    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'".

  2. MohammedU New Member

    May be you are dropping the object but not creating.

    Mohammed U.

Share This Page