mellenburg
Programmer
We're moving from SQL Server 2000 to 2005. In 2000, I had a development, test, and production database. I had written a variety of DTS packages to move select objects from development to test, and from test to production. I wasn't doing an entire DB copy because I wanted to be able to move specific objects.
In 2005, I understand that DTS has been replaced by SSIS. So, I now want to replicate that exact functionality on the 2005 server. I don't want to use DTS anymore.
How do I create an SSIS package that will allow me to select specific database objects (tables, views, stored procedures) and copy them from one 2005 DB to another 2005 DB? Furthermore, I would like the solution to reside on the DB server like the DTS packages did so that multiple users can execute the package.
In 2005, I understand that DTS has been replaced by SSIS. So, I now want to replicate that exact functionality on the 2005 server. I don't want to use DTS anymore.
How do I create an SSIS package that will allow me to select specific database objects (tables, views, stored procedures) and copy them from one 2005 DB to another 2005 DB? Furthermore, I would like the solution to reside on the DB server like the DTS packages did so that multiple users can execute the package.