August 8, 2011 at 5:56 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy