I have an application and I want to move some of the tables from the production database to the development database to refresh the data on development. I don't need to move all of the tables.
This application is still running on SQL2000 and planned to be upgraded next year. I have SQL2008 installed on my workstation. I was thinking about using SSIS for this, but not sure that it will work. Is this the best way or is there something easier? I would like this to be automated so I can do it when needed.
Thanks in advance,
Randy