SSIS - best approach

[meckeard]

Hi all,

I'm in need of copying tables from DatabaseA to DatabaseB, both of which reside on the same server. This is needed to get the proir days data in to a reporting database (DatabaseB).

A restore would be easy but there are database objects exclusive to DatabaseB and they would get overwritten.

What's the best approach in my scenario? There are dozens of tables that need to be moved and I need the data to identical. I don't know the data well enough to determine what has changed and get just that data. That's why I'm thinking of copying all the tables.

Thanks,
Mark

 

[TheBugSlayer]

I believe you could right-click on your database and choose Tasks->Export Data and follow the wizard's steps. You will have the option to save into an SSIS package. Next you only need to schedule the execution of that package.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)