SQL 2005 Integration Services problems -
09-15-2008
, 03:12 PM
I had some DTS's from SQL 2000 that I brought over to SQL 2005. It was
doing a lot of date code manipulation, etc, and have gotten it to work
in the Legacy DTS.
Once I go over to Integration Services & import it there, it shows up
and I try to execute it. It died originally with permission type
messages.
I got rid of those by giving the package db owner access.
Now, I've got a new message:
Error ComException 0x80040427;
Execution was canceled by user. at dts.package.execute().........
No idea what the heck this error is. I haven't canceled anything.
Any ideas?
BC |