Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Refreshing All Tables in SQLServer 2005

Author  Topic  dbaman Starting Member 46 Posts Posted - 2007-02-07 : 10:35:29 I want to refresh all the tables of SQLServer2005 database. Both the source and the destination database are in different server, although both running SQLServer 2005. When I tried IMPORT/EXPORT Data wizard I keep getting error Table already exists. The thing is in my destination database I have several Stored Procedures so I can't drop the existing tables. Please suggest. R