February 9, 2012 at 9:39 am
I have 2 packages.
A master package calls a sub-package.
When I fire the master package from BIDS, everything works.
When I fire the master package from within a SQL Server Agent job, everything works.
But when I double click on my master package and try to execute it, it fails when trying to call the sub-package with an error message like
Package migration from version 2 to version 3 failed with error 0x80004003 "Invalid pointer".
My package is 2005 but my development machine has 2005, 2008 and 2008R2 installed.
This is not really life threatening but I'd like to understand if possible because it could be useful to use DtexecUI from time to time.
Thanks
Eric
February 10, 2012 at 1:30 am
Are you sure you are using the DTEXECUI of the correct version?
Maybe it calls the DTEXEC from a different version, hence the failure.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 2:14 am
Indeed... If I choose the executable directly rather than double clicking on the package, it works fine.
Once again, thanks a bunch! :w00t:
February 10, 2012 at 2:24 am
Eric Mamet (2/10/2012)
Indeed... If I choose the executable directly rather than double clicking on the package, it works fine.Once again, thanks a bunch! :w00t:
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply