Post reply

Transactions in SSIS

  • August 8, 2011 at 5:56 am

    #390139

    Hi ,

    I am working on migrating historical data from hospitals.

    I want to use transaction in SSIS package. The data transfer is based on hospital number and year. I will be using execute sql task with stored procedures. There are many hospitals with 10 years of mediacal data. Is it possible to use transactions based on yearly data with single hospital.

    Any suggestions?

    Thanks in advance

  • August 8, 2011 at 6:05 am

    #1365129

    If you create a stored procedure that inserts/updates data based on hospital and a year, that you can encapsulate that stored procedure into a transaction and just execute that stored procedure multiple times.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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