How to call DLL functions from SSIS

• sleepycasper

  SSC Journeyman

  Points: 85

  More actions

  September 11, 2009 at 1:50 am

  #138004

  Hi all,

  We are using SSIS and would like to call some functions from DLL.

  Someone had mentioned like late binding and com intrepret.

  Any ideas?

  Thanks and regards.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  September 11, 2009 at 12:55 pm

  #1052511

  sleepycasper (9/11/2009)

  ---

  Hi all,

  We are using SSIS and would like to call some functions from DLL.

  Someone had mentioned like late binding and com intrepret.

  Any ideas?

  Thanks and regards.

  Does your DLL expose COM objects or you have regular C++ functions?

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  

• Jeff Moden

  SSC Guru

  Points: 1004406

  More actions

  September 11, 2009 at 9:27 pm

  #1052643

  sleepycasper (9/11/2009)

  ---

  Hi all,

  We are using SSIS and would like to call some functions from DLL.

  Someone had mentioned like late binding and com intrepret.

  Any ideas?

  Thanks and regards.

  I can't help with much of anything in SSIS because I don't use it. I am curious though... what do the DLL's do?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• ab5sr

  SSCarpal Tunnel

  Points: 4056

  More actions

  September 11, 2009 at 10:30 pm

  #1052658

  Forget all of that com stuff and interop stuff...search Google for c# assemblies for SSIS or building custom assemblies for SSIS. I have a post on my blog that you can read, step by step in building one broski. (Didn't someone post this same question earlier today?). These are a great way to extend the functionality of SQL Server by rolling a procedural language into the mix. A possibly even better way to handle it would be to take that same function, put it in a web service, and call from SSIS.