Friday, March 9, 2012

Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException HResult -2146233088

i get the following exception HResult -2146233088

[Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException] {"No description found"} Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException

when i try to use this following code snippet

try

{

ConnectionManager objOLEDBConnection;

Microsoft.SqlServer.Dts.Runtime.Package objPackage = new Microsoft.SqlServer.Dts.Runtime.Package();

objOLEDBConnection = objPackage.Connections.Add("OLEDB");

}

catch(Exception ex)

{

ex.Message ;

}

could you please help me out with this ?

Moving to the SSIS forum.|||

Have you seen this help article that shows adding an OLE-DB connection to a package - http://msdn2.microsoft.com/en-us/library/d90716d1-4c65-466c-b82c-4aabbee1e3e5(SQL.90).aspx

What is the actual line that throws the exception?

The code looks OK, but knowing where the exception is raised may help.

Is SSIS correctly installed on your PC?

Is the OLE-DB connection available if you use the designer?

No comments:

Post a Comment