forum.venkateswarlu.net
      Register      Login
multiple databases as single source and load to table

No replies to this topic

Guru Nadh #1
Member
22 Points
Posted on 02 Jul 2014 01:31 PM IST hi, i have one query. In my sql server having 4 databases like hyd_db, bng_db, che_db, mum_db. i want all this db's in single source and load to a  table.  In all this databases having one same table named as emp, which is having same structures in all db's. i want to load emp table from all databases to another database. Can you suggest how to write this query 
SQL Server,SSIS     685 views     Reply to this topic