SSIS Custom Component issue

• rvphx

  SSCrazy

  Points: 2120

  More actions

  June 27, 2012 at 1:40 pm

  #276974

  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.

• rvphx

  SSCrazy

  Points: 2120

  More actions

  June 27, 2012 at 2:17 pm

  #1506367

  Finally an answer! http://blogs.msdn.com/b/mattm/archive/2008/08/22/accessing-oledb-connection-managers-in-a-script.aspx