February 15, 2008 at 1:49 pm
Hello,
When using SSMS to export/import data, it uses SSIS to perform this task. Since the options are limited in doing this, I'm curious to as if export/import is done inside a transaction? I saved out a package to see If I could find out, and under transaction options, I see TransactionOption is set to "supported". This doesn't help ...
I just need to know If I cancel this 30 million record copy if I'm going to get stuck in a rollback or not. I still have another 20 million records to go, and it's Friday! I don't want to be stuck here ...
Thanks
February 16, 2008 at 8:30 am
Here is a link to an article on this site that answers your question:
Basically is says that Supported means if a transaction was started by the process that calls the SSIS package the package will be part of the transaction.
I would guess in your case it is not part of a transaction and you will not get stuck in a rollback.
Kinda late for the response, I know.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply