Home Forums SQL Server 2005 T-SQL (SS2K5) Logic question regarding inserting of rows from 1 table to another. RE: Logic question regarding inserting of rows from 1 table to another.

  • If all columns are defined in both tables and all columns have default values, here is a possible solution.

    Microsoft has a package for backwards compatibility with 2005, I think the install is named SQLServer2005_DTS.msi. There are many tools in the package, but one of them, which I use a lot, and which works on 2005, is called DTSWizard.exe. You can create a package with it and run as a job or do a one time run. It will copy one table to another table, and you can write a query to tell it what or how much or how to copy. You can get the download from download.microsoft.com