ARTICLE

Error Opening SSIS Package

Posted by Justin Finch Articles | Error Zone May 30, 2007
Tags: SSIS, SSIS Package, Error Opening SSIS, VS2005
I got a weird error when trying to open an SSIS package in VS2005.
Reader Level:

I ran across a weird error when I was trying to open an existing SSIS package in VS2005.

Error 1. Error loading 'Package.dtsx' : Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))

To fix the problem do the following:

  1. Open the command prompt
  2. Navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
  3. Run C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll

That should fix the problem.

Login to add your contents and source code to this article
This Feature is Sponsored By DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.
post comment
     

Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass app = new Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass();
string packagePath=@"C:\Paramount\Internal Projects\TestSSISPackage\TestSSISPackage\bin\Package.dtsx";
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackage90 package = app.LoadPackage(packagePath, true, null);
package.Execute(); 

Posted by Gaurav Jain Mar 25, 2010

This is Working solution for
Using SSIS VS 2005 Package In VS 2008 With C# 3.5

Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass app = new Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass();
string packagePath=@"C:\Paramount\Internal Projects\TestSSISPackage\TestSSISPackage\bin\Package.dtsx";
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackage90 package = app.LoadPackage(packagePath, true, null);
package.Execute(); 

Posted by Gaurav Jain Mar 25, 2010

HI, i m trying to store my csv file into database i m getting an error on managedOleInstance.AcquireConnections(null); and my application stops working!! And package did not get generated ! So I have commented that line ! Then it give me an error at this line managedFlatFileInstance.ReinitializeMetaData(); so have commented all lines that called AcquireConnections(null); ReinitializeMetaData(); So now my package gets generated but it gives me an error it gives error that output column is not synchronized with externalmetadata column.. Column "Name" has to be added to the externalmetadatacolumn Column "Age" has to be added to the externalmetadatacolumn Column "JoinDate" has to be added to the externalmetadatacolumn Column "salary" has to be added to the externalmetadatacolumn column "Retierd" has to be added to the externalmetadatacolumn

Posted by Ripal Feb 05, 2008
COMMENT USING
PREMIUM SPONSORS
Over-C is a holistic consortium of communications and technology specialists. We build, deploy and market both business as well as consumer products and solutions.
TRENDING UP
MOST LIKED ARTICLE
HOT KEYWORDS
SPONSORED BY
  • PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.
Get Career Advice from Experts
WHITEPAPERS AND BOOKS
Hosted By CBeyond Cloud Services MVPs MOST VIEWEDLEGENDSNOW PRIZESAWARDSREVIEWSSURVEYCERTIFICATIONSDOWNLOADS
PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE
©2013 C# Corner. All contents are copyright of their authors.