August 19, 2013 at 11:47 am
I am getting the error below while executing the package,
Error: System. Runtime InteropServices.COException [0x80040427]: Execution was cancelled by user. at DTS.PackageClass.Execute{} at Microsoft
Help is appreciated,
Thanks,
Bubby
August 19, 2013 at 1:04 pm
How are you running the package, BIDS, SQL Agent, DTEXEC?
What does the package do?
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
August 19, 2013 at 2:26 pm
DTSEXEC
August 19, 2013 at 2:54 pm
Okay, re-reading your first post makes me think you are have a COM Object that doesn't exist on the server you are running the package on.
If you are using any Office (Excel) then you need to make sure you are running the 32-bit DTExec found in Program Files(x86).
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
August 19, 2013 at 3:03 pm
I have a package rpd.dtsx and trying to execute and get the above mentioned error
August 19, 2013 at 3:14 pm
What are you trying to do in the package? If you are using Excel as source or destination you need to use the 32-bit DTExec as I mentioned in my previous post.
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
August 19, 2013 at 3:19 pm
How to change the properties to 32 bit for package please
August 19, 2013 at 3:27 pm
Here's a great blog post about it, http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html
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 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply