Showing posts with label loading. Show all posts
Showing posts with label loading. Show all posts

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

error when loading datas to table

sir,
i am facing an error when loading datas into tables.Can you please give us a description of the actual error.
Peter
"Facts are stupid things."
Ronald Reagan
>--Original Message--
>sir,
> i am facing an error when loading datas into tables.
>.
>

Monday, March 19, 2012

Error when creating DMX query

On screen states [Error loading mining model metadata: No Metadata found]

and on the functions states [Error loading functions: no functions found]

This also occures when trying to use the Data mining wizard, it will just not respond.

Have deleted and removed all references to SQL2005 Standard and reloaded and still get same errors

Could someone please advise, have sent errors to Microsoft with no responce back yet.

I assume you are using the DMX query in SQL Management Studio?

These results occur when you have a database selected that doesn't contain any mining models. If you select a database in the database selector on the toolbar that contains models, you will get the list of models in the database in that pane of the user interface.

Also you could just do

"CREATE MINING MODEL foo ( custid LONG KEY, MyColumn LONG CONTINUOUS) USING Microsoft_Clustering"

and that would create a model in the current database that should show up in the metadata browser.

Given that you have issues using the wizard as well, it sounds like there may be some other issues. Can you provide more details?

Thanks,

-Jamie