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:
-
Open the command prompt
-
Navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
-
Run C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll
That should fix the problem.
Gaurav JainPosted Mar 25, 2010, 8:10 AM
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();
Gaurav JainPosted Mar 25, 2010, 8:09 AM
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();
RipalPosted Feb 5, 2008, 12:31 AM
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