Post reply

Where the SSIS stores the data temporarily

  • May 28, 2009 at 6:43 am

    #132700

    Hi,

    I have to pull the data from one database to another database(Using OleDB Source and Destination Controls). Both are SQL Db's. I created the package and ran it. I manually stop debugging when it shows some count. When i go and check my SQL table the data is not available. It is available only when it completes the execution, or terminate itself due to some errors. Y is it so? pls help me

  • May 28, 2009 at 8:50 am

    #1001473

    anandhakrishnabca (5/28/2009)

    Hi,

    I have to pull the data from one database to another database(Using OleDB Source and Destination Controls). Both are SQL Db's. I created the package and ran it. I manually stop debugging when it shows some count. When i go and check my SQL table the data is not available. It is available only when it completes the execution, or terminate itself due to some errors. Y is it so? pls help me

    Do you execute in transaction? If that is the case, the data is not going to be visible until you commit the transaction.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

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