Hello,
I have a question...
I am using BIDS to create a project that refreshes a test database with production data, and it seems that SSIS has a fundamental problem with dropping and recreating tables in a database, or deleting the rows in a table. Whenever I select drop and recreate tables or delete all rows in table using the SQL Transfer objects task or the import export wizard, I receive an error that says I cannot insert a duplicate primary key, which tells me it did not drop the tables or delete the rows in the table.
Is anyone else having issues like this?
Any help would be appreciated...
I have a question...
I am using BIDS to create a project that refreshes a test database with production data, and it seems that SSIS has a fundamental problem with dropping and recreating tables in a database, or deleting the rows in a table. Whenever I select drop and recreate tables or delete all rows in table using the SQL Transfer objects task or the import export wizard, I receive an error that says I cannot insert a duplicate primary key, which tells me it did not drop the tables or delete the rows in the table.
Is anyone else having issues like this?
Any help would be appreciated...
