How to call DLL functions from SSIS

Question

Post reply

How to call DLL functions from SSIS

sleepycasper

Valued Member

Points: 55
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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

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: 1000539 More actions · Answer 2

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)
Intro to Tally Tables and Functions

ab5sr Hall of Fame Points: 3912 More actions · Answer 3

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.