June 5, 2012 at 8:50 am
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 !!
June 5, 2012 at 11:03 am
Nidhi G (6/5/2012)
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 !!
Have you thought about doing this using a SQL script?
Do you really mean 'move'? Or copy?
Does this need to be re-runnable, or is it a one-off?
Do you need to create the DDL for the tables as well as the DML?
Please put down your requirements in a bit more detail.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 5, 2012 at 11:06 am
I need to do it using SSIS only. I mean I have to copy the data.
June 5, 2012 at 11:09 am
Please answer my other questions and justify the use of SSIS.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply