Friday, March 23, 2012

Error when loading Package

Hi all,
I've finished an SSIS Package on my computer and want to move the project into production server. I was just copied the whole files and when I load the package from production server there was an error occured, the description is below :

Error 1 Error loading 'SC2DC_Regular.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. . e:\dw workplace\sc2dc_server\SC2DC_Regular.dtsx 1 1

What's the problem with my Package, I never met this error before with the same behaviour of moving SSIS project from one computer to another.
Thanks in advance

Is you production server 64-bit? If so, the problem may be that your scripts are not precompiled. Make sure your PreCompileScriptIntoBinaryCode is True (the default). Scripts are compiled when the script editor IDE is closed, so you may need to open and close the scripts (tasks and components) to get them to compile.
|||The property is True and like I wrote before I moved my previous project to that production server and it's work fine. Only this current project I got this error.|||Hi all,
Does anyone know what's the real problem with my package ?|||Hi,
after searching the answer for days I found this thread :

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1244365&SiteID=1

no wonder there's no people here tried to answered my question ;p except JayH, thanks bro :-)

sql

No comments:

Post a Comment