SSIS

• dsrapid

  SSC-Addicted

  Points: 485

  More actions

  June 5, 2012 at 9:19 am

  #261964

  Hi,

  I need to create a package in SSIS 2008 for the following task:

  I have a database name OMB. In that database i have different schemas like bau,ssi,stg etc..

  I need to move data for all the tables of bau schema in OMB database from dev area to UAT area. Please help me how can I create the package.

  Thanks in advance !!

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  June 6, 2012 at 1:23 am

  #1497433

  2 connection managers, 1 for DEV, the other for UAT, then you need to use as many data flow tasks as you want to copy the tables from DEV to UAT

• Rock from VbCity

  Hall of Fame

  Points: 3991

  More actions

  June 6, 2012 at 2:42 am

  #1497459

  Adding to Antony`s answer, you can do that with SSMS export feature.

  Hope this helps,
  Rock from VbCity