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