March 26, 2012 at 3:22 am
I had a package running on production since last 2 years. Suddenly I am getting below error
Could not load package "\MSDB\PROD_GAPS\Nightly_Load_GPExtract" because of error 0x80040154.
Description: The package failed to load due to error 0x80040154 "Class not registered". This occurs when CPackage::LoadFromXML fails.
No change has been made lately to the package.
What could be the reason for teh error.. Any Ideas??
March 26, 2012 at 3:34 am
Has anything changed on the server?
What does the package do? What are the tasks/components/connection managers used?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2012 at 3:37 am
Nothing has changed on the server also..
Its a simple etl.. takes few records from SQL server and put them on a text file
March 26, 2012 at 3:50 am
No special connection managers or providers? No script tasks or something like that?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2012 at 4:00 am
No.. not at all..
March 27, 2012 at 2:12 am
Go to your control panel, add/remove programs and repair/reinstall your MSXML 4 or 6 (the latest one you have which depends on which SQL Server version you have) as we find this often fixes similar issues especially after windows updates have run.
Viewing 6 posts - 1 through 6 (of 6 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