.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Get error on runing Package - ComVisible

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
hi all im try to run a simple package with 2 Execute SQL Task and im get this error : Error: The Execute method on the task returned error code 0x80131509 (This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.). The Execute method must succeed, and indicate the result using an "out" parameter. any help

View Complete Post

More Related Resource Links

Error while executing a package through SQL Server Agent

Hi All,   I have a ssis package. It has 3 tasks, first task updates a record in Oracle database to set an Indicator to “Y”, second task process SSAS Cube and the third again updates the same record and sets the indicator to “N”. This package has 2 data sources, one is Oracle and the other is Analysis Services. I gave the credentials for the Oracle and use NT Authority for Analysis services.   When I am executing from BIDS package is executing successfully. But when I am calling the job to execute this package its throwing me the error. Below is the error.     Message Executed as user: User\Username. ...ion 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:57:46 AM  Error: 2010-08-27 10:57:46.79     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2010-08-27 10:57:47.16     Code: 0xC0202009     Source: Ord_test Connection manager &q

SSIS Package working on SQL Client Machine but when trying to run on SQL Server machine giving error

Hi We are trying to run SSIS package on sql server machine but sometimes it is giving error for data flow task containing Script Component. Error is - [SSIS.Pipeline] Error: component "SCR DimensionRelation" (1) failed the post-execute phase and returned error code 0x80004002. This error is not coming continuously. And also not for specific DFT. It comes for different DFTs as we rerun the package. Can anybody help me on this? We are using SQL server 2008. We are not getting any error on client machine :(:(

Error Importing SSIS Package

I can't import a package from the SSIS to the file system of my SQL Server Management Studio. Every time i've tried the following message appears. What should i do to correct this problem? Any ideas?   =================================== Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS) ------------------------------Program Location:    at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)   at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

SSIS Package returns the error - The command execution generated errors.

SSIS Package returns the error - 'The command execution generated errors'. Please let us know the cause for this error if anyone encountered this error before. Require a solution for this.   Thanks

.net framework 3.5 full package error in installation

i downloaded the full package and when it went to the install part it started then it said an error has occurred deleting all files downloaded :( i have windows xp professional, 200gb hard drive 1.5gb ram hp pavilion a1310n i get this error msg plz help [04/11/10,19:44:09] Microsoft .NET Framework 2.0a: [2] Error: Installation failed for component Microsoft .NET Framework 2.0a. MSI returned error code 1603 [04/11/10,19:44:28] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0a is not installed. [04/11/10,20:01:47] Microsoft .NET Framework 3.0a: [2] Error: Installation failed for component Microsoft .NET Framework 3.0a. MSI returned error code 1603 [04/11/10,20:02:08] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0a is not installed. [04/11/10,21:13:34] Microsoft .NET Framework 2.0a: [2] Error: Installation failed for component Microsoft .NET Framework 2.0a. MSI returned error code 1603 [04/11/10,21:14:01] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0a is not installed. [04/11/10,21:33:18] Microsoft .NET Framework 3.0a: [2] Error: Installation failed for component Microsoft .NET Framework 3.0a. MSI returned error code 1603 [04/11/10,21:33:42] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0a is not installed.

SSIS Package Protection Level Errors - decrypt protected XML node "DTS:Password" with error 0x800900

Error 7 Error loading GetData.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.   c:\Packages\GetData.dtsx 1 1  Error 8 Validation error. Data Flow Task: OLEDB Source [5310]: The AcquireConnection method call to the connection manager "SourceServer" failed with error code 0xC0202009. GetData.dtsx 0 0 Environment I need to execute - BIDSHave Solution, with files linked with VSS. When I click on package, aforesaid errors show up and package opens in designed.Protection Level : Encrypt Sesitive with User KeyThis means it'd run only on machine and by user where and who created respectively.So I changed it to Encrypt Sesitive with Passoword and provided Passoword. No luckSo I changed it to Do not save sensitive, as anyways in the connection manager, it has Expression saying @Variablename (with appropriate correct syntax), and variable is mapped to config file. I tired with Config file and also by hardcoding the value in the connection manager's connection string after removing the variable name, also tried by hardcoding value in variable value and disabling config file.Nothing works. I read 3 threads discussing this issue by othe

SSIS package is giving error when ran thru JOB...its running good when I execute in BI Studio or Exe

Friends I am getting weird issue...I built an SSIS package. In one variable I used express builder and built like this... RTRIM( (DT_STR, 2,1252)  (((DT_I4) ( (DT_WSTR, 3) (SUBSTRING( @[system::machineName] , 12, 16 ))) +1) /2)) when I run the package outside ie., with VStudio or execute utility it running absolutely with out any problem. But when I created a job just to execute that package in particular timings...the job is totally failing by throwing error....the error output is like the following: Started:  10:22:33 AM Error: 2010-02-27 10:23:06.23    Code: 0xC00470C2    Source: Rerun_MissingFiles    Description: Error code 0x80020005 occurred attempting to convert from data type DT_WSTR to data type DT_I4. Error: 2010-02-27 10:23:06.23    Code: 0xC00470C4    Source: Rerun_MissingFiles    Description: Casting expression "(SUBSTRING( @[system::machineName] , 12, 16 )))" from data type "DT_WSTR" to data type "DT_I4" failed with error code 0xC00470C2. End Error Can any one help me please? Thanks in advance.

.NET Framework 4.0 Full package installation failed with error code: (0x80070643)

I am getting an error when installing .net framework 4.0. I am using the full package installer. OS: windows XP Service Pack 3 Windows Update: Current with all security updates. Error: [7/12/2010, 10:50:49]MSI (C:\eb1ddbb12a129b2fddde4054\netfx_Core_x86.msi) Installation failed. Msi Log: Microsoft .NET Framework 4 Setup_20100712_105014316-MSI_netfx_Core_x86.msi.txt [7/12/2010, 10:50:49]PerformOperation returned 1603 (translates to HRESULT = 0x80070643) [7/12/2010, 10:50:49] Action complete [7/12/2010, 10:50:49]OnFailureBehavior for this item is to Rollback. [7/12/2010, 10:50:49] Action: Performing actions on all Items... [7/12/2010, 10:50:49] Action complete [7/12/2010, 10:50:49] Action complete [7/12/2010, 10:50:57]C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz - Signature verified successfully for netfx_Extended.mzz [7/12/2010, 10:50:57] C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz Signature verified successfully for netfx_Extended.mzz [7/12/2010, 10:50:57]Signature verification succeeded for netfx_Extended.mzz [7/12/2010, 10:50:57]File C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz, locked for install. [7/12/2010, 10:50:57]Verifying Digital Signatures: C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz Success [7/12/2010, 10:50:57]Final Result: Installation failed with error code: (0x80070643), "Fatal error during installation. " (Elapsed time: 0 00:00

Error loading package

Hi there all... We've just started using SSIS packages, and everything seems to be going ok. I've recently set up a couple of jobs which just run an SSIS package every 5 minutes to collect data.These run fine 90% of the time, but intermittantly produce an error. When using a SSIS task in the job it simply reported"Could not load Package." I have changed these to use DTExec as I heard it gave more verbose execution results, and now I get an error like"Executed as user: NZ\SQLAdmin. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.1399.06 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  8:25:00 a.m.  Could not load package "\MSDB\RadiusBilling\Get_RADIUS_AuthLog" because of error 0x80040E37.  Description: Table/view either does not exist or contains errors.  Source: Microsoft SQL Native Client  Started:  8:25:00 a.m.  Finished: 8:25:00 a.m.  Elapsed:  0.047 seconds.  Process Exit Code 5.  The step failed." So far I have not been able to find anyone else with similar errors.Whenever the package executes it seems to run fine, so this seems to be an error just getting the package to execute in the first place, and as I said it only happens internittantly. The packages talk to a SQL2005 server using windows authentication (which I assume is inherited from the SQLAgent service user), as well as a MySQL

Package Migration Wizard error -- Index was out of range

I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions?"Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index (mscorlib) ------------------------------Program Location:    at System.Collections.ArrayList.get_Item(Int32 index)   at WizardUI.ListPackages.UniquePackagewithCurrentVersion(PackageInfoCollection m_pInfoCol)   at WizardUI.ListPackages.OnEnterPage(EventArgs e)   at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()   at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)   at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)"

Implementing Transaction in SSIS Package - [Execute SQL Task] Error: Failed to acquire connection "<

I have a simple SSIS package with three "Execute SQL Tasks". I am using ADO.Net Connection to execute SPs on a DB server. When I execute this package It works fine. So far so good. Now, I need to implement transation on this package. And problem starts now onwards. When I try to execute package after setting TransationOption = Required for the Sequence container which contains all the tasks, I get following error. [Execute SQL Task] Error: Failed to acquire connection "NYCDB0008.Export". Connection may not be configured correctly or you may not have the right permissions on this connection. "NYCDB0008.Export" is the name of the ADO.Net connection. I have been hunting for any solution but all in vain. I have tried changing all DTC settings on the dev as well as Database server. Please respond if anyone has any solution. Thanks! Anand

SSIS Import Package Error - DTSRuntimeWrap 0xC0010026

Hi, I have a problem with importing dtsx package on SSIS 2008. When I try to import this in SSIS MSDB, I have an Exception from HRESULT: 0xC0010026 (Microsoft.SqlServer.DTSRuntimeWrap). The related topic does not help me, because the package is generated in 2008 version, imported with 2008 Management Studio. Any idea? Thanks a lot, Giovanni

"Failed to save package file" error


I receive the following error while trying to create a new project in BIDS:

"Failed to save package file "C:\Users\<username>\Local Settings\Temp\2\tmpCAD.tmp" with error 0xC020207E "The file name is not valid.  The file name is a device or contains invalid characters"

Environment is:

Windows 2008 Server SP1 (64 bit)

Visual Studio Team System 2008

Any ideas?

Error while executing SSIS package from a Stored Procedure


I am getting an error while executing a SSIS Package from SQL Server Stored Procedure.  But when I run it in BIDS, it executes successfully. Any help on this ???

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured.  Error Code: 0x80040ED. An OLE DB record is available. Source "Microsoft OLE DB Provider for Oracle" Hresult 0x80040eD Description: "ORA-01017: invalid username/password; logon denied"

Could not load package because of error 0xC001000A

I am trying to run an SSIS Package by using DTRun.exe this way
C:\Documents and Settings\Fahad>dtexec /SQL DataDownload /Conn "Data Source
=TriMurti;User ID=sa;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate
=False;Password=gamba" /U sa /P gamba

And the outcome of the command was
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  9:03:52 AM
Could not load package "DataDownload" because of error 0xC001000A.
Description: The specified package could not be loaded from the SQL Server database.
Started:  9:03:52 AM
Finished: 9:03:52 AM
Elapsed:  0.25 seconds

Any help in this will sincerely be appreciated.


dtutil won't deploy my package, "error 0xc0011008 loading from XML"


My package runs fine on the dev server with remote database.  SSMS deploys it to the msdb on the remote server, no problem, and it runs there with no problem.

But when I try to use dtutil from the command line to deploy it from a local .dtsx file to the remote server, I get the following message:

Microsoft (R) SQL Server SSIS Package Utilities

Version 9.00.1399.06 for 32-bit

Copyright (C) Microsoft Corp 1984-2004. All rights reserved.

Could not load package "foo.dtsx" because of error 0xC0011008.

Description: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.


Dev system is using Visual Studio 2008 and BI Studio R2, database server is SQl 2008 but not R2.

I don't think that matters.

What might matter is that I have embedded spaces in the file names and package names - just renaming the file didn't seem to help, I think I'll try renaming the package, for lack of any better idea to try.

Or, could it be a 32bit/64bit thing?  I'm not sure who is 32bit and who is 64bits, actually.





Package connection error to DB2 host


Connecting to a DB2 host the error is coming up 'Use does not have authority etc etc'

Here's the scenario.

BIDS test connection works fine.

I am using Package Configuration and have verified that the username and password in the xml are working.

I deploy the package via the deployment wizard.

Run the package and it fails with :


Then another error message 5 lines down:

"The user does not have the authority on the host resource"

I suspect the username and password are not being passed over.

I am at a loss. The xml config file definetly has the username and password in it.

Any help much appreciated.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend