Post reply

SSIS package craetion

  • June 5, 2012 at 8:50 am

    #392434

    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

    #1497198

    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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 5, 2012 at 11:06 am

    #1497199

    I need to do it using SSIS only. I mean I have to copy the data.

  • June 5, 2012 at 11:09 am

    #1497200

    Please answer my other questions and justify the use of SSIS.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply