Tuesday, March 20, 2012

Package executes on test database but not in production database

hi!

I am able to run the package successfuly in test database. but not in production database. It throughs up error saying

Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.
Description: Failed to open package file "D:\\TAHOE\\APPS\\SSISPackages\\Integration Services Packages\\ArchiveMain.dtsx" due to error 0x80070015 "The device is not ready.". This happens when loading a package and the file cannot be opened or loaded c
orrectly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
End Error
Could not load package "D:\\TAHOE\\APPS\\SSISPackages\\Integration Services Packages\\ArchiveMain.dtsx" because of error 0xC0011002.
Description: Failed to open package file "D:\\TAHOE\\APPS\\SSISPackages\\Integration Services Packages\\ArchiveMain.dtsx" due to error 0x80070015 "The device is not ready.". This happens when loading a package and the file cannot be opened or loaded corr
ectly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.

what is the problem here....

JAs

Has somebody dealt with this error before. If yes please help me out.

thanks,

Ja

|||what are you using to execute the package in the production db? code? dtexec? sql server agent?|||

i solved the problem. Anyway i am executing through dtexec. I trying to execute the package with different Databases. One with my test and other with production.The Test database was in my own machine. where as the production was pointing at remote server.So the package was in my machines folder path and worked correctly. when i tried to execute with the production database from my machine. It threw up error saying cannot find the pacakge path cos it was trying to scearch my my production servers machine.

Thanks for your reply,

jas

No comments:

Post a Comment