Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to merge SQL 2005 database files RE: How to merge SQL 2005 database files
SQLdevotee
SSCarpal Tunnel
Points: 4820
More actions
February 21, 2008 at 11:07 am
#780793
Try using OLE DB source>>Union ALL>>OLE DB Destination
*OLE DB Source will contain ALL your Database tables that you want to bring in
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]