Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copy SQL Server Objects Problem
Not sure about doing that with the wizards, but that same if exists statement, can probably be used to control the copies.- dpostman
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
Copy SQL Server Objects Problem
this bid of sql should take care of the table already exists problems. I believe if you set up your package to drop and recreate the tables it will produce this automatically before the create statement. (put your table name in place of YourTableNameHere) if exists (select * from...- dpostman
- Post #2
- Forum: Microsoft SQL Server: Data Transformation Services
