I have developed a custom component in SSIS and it is not functioning in a way I would expect it to.
The following few lines check to see if either of ADO.NET / OLEDB connections exist. But for some reason, its working only for the ADO.NET connection type. Can someone tell me whats wrong here?
if (!(connection is SqlConnection || connection is OleDbConnection))
{
componentEvents.FireError(0, METHOD_NAME, "The connection is not a valid ADO.NET connection", "", -1);
return DTSExecResult.Failure;
}
Any help on this is really appreciated.