SSIS reusable funtions

Question

SSIS reusable funtions

Viewing 7 posts - 16 through 21 (of 21 total)

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

Gazareth One Orange Chip Points: 27737 More actions · Answer 1

Ah, thanks Phil, I didn't know that.

Although if you're doing all that, I wonder why SSIS would be used at all in this case.

Surely at that point SSIS has basically just become a GUI for creating the source & destination file connection objects?

Regards

Gaz

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Phil Parkin (2/2/2012)
There's no such thing as reusable functions in SSIS ...
That's not quite true, though it certainly isn't as easy as it might be. If you are prepared to venture into the world of custom assemblies and the GAC, it is all possible. Here's a link which gives an example.

I especially left out this option because creating custom components/tasks for SSIS is much easier than asking the DBA's to create a simple stored procedure. 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246965 More actions · Answer 3

Koen Verbeeck (2/2/2012)
Phil Parkin (2/2/2012)
There's no such thing as reusable functions in SSIS ...
That's not quite true, though it certainly isn't as easy as it might be. If you are prepared to venture into the world of custom assemblies and the GAC, it is all possible. Here's a link which gives an example.
I especially left out this option because creating custom components/tasks for SSIS is much easier than asking the DBA's to create a simple stored procedure. 😀

I shall add this post as my bookmarked definition for the word 'sarcasm'.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Phil Parkin SSC Guru Points: 246965 More actions · Answer 4

Gazareth (2/2/2012)
Ah, thanks Phil, I didn't know that.
Although if you're doing all that, I wonder why SSIS would be used at all in this case.
Surely at that point SSIS has basically just become a GUI for creating the source & destination file connection objects?
Regards
Gaz

It's not the most heavily used feature, that's for sure.

For developers of third-party add-on software (Cozyroc, where are you? 🙂 ), it's pretty handy.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Gazareth One Orange Chip Points: 27737 More actions · Answer 5

Koen Verbeeck (2/2/2012)
I especially left out this option because creating custom components/tasks for SSIS is much easier than asking the DBA's to create a simple stored procedure. 😀

Undoubtedly 😀

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

Gazareth (2/2/2012)
Koen Verbeeck (2/2/2012)
I especially left out this option because creating custom components/tasks for SSIS is much easier than asking the DBA's to create a simple stored procedure. 😀
Undoubtedly 😀

I have to agree, custom tasks are.. A challenge..

But there are examples on codeplex that work pretty well and I have had the pleasure (not sure if thats the right word) of doing a couple.. Unless you do it a lot you forget a lot and have to re-learn the tricks each time..

CEWII

herladygeekedness SSCertifiable Points: 5878 More actions · Answer 7

My thought is that the options are laid out for you in this thread. Creating a custom component would be my choice given your stated requirements/limitations, if it MUST be SSIS.