Home Dashboard Directory Help
Search

Add user defined function support to the SSIS expression language by Duane Douglas


Status: 

Closed
 as Won't Fix Help for as Won't Fix


38
0
Sign in
to vote
Type: Suggestion
ID: 166367
Opened: 7/18/2006 11:47:37 PM
Access Restriction: Public
0
Workaround(s)
view

Description

Currently, the SSIS expression language doesn't support user defined functions. Therefore, it may be necessary to re-create the same complex expression repeatedly. Adding support for user defined functions to the SSIS expression language would simplify the re-creation of complex expressions.
Details
Sign in to post a comment.
Posted by AndreyM3 on 5/17/2012 at 2:13 AM
I really would like to have this feature in SSIS.
Posted by Bryan RES on 3/7/2012 at 8:42 AM
I'd also like to see this added as a feature in the next edition.

The ability to extend SSIS packages using Microsoft's flagship .NET Framework seems like a no-brainer.

Why wouldn't Microsoft do it?
Posted by Valentino Vranken on 3/7/2012 at 5:01 AM
Wanted to file the same request and stumbled upon this one, so I totally agree! Even SSRS can do it!
Posted by John Mao on 1/12/2012 at 8:01 AM
I keep running into this issue...
Posted by buddylee17 on 4/8/2011 at 1:56 PM
Why is this closed? The competitors already have this functionality...
Posted by Lawi on 3/25/2011 at 4:37 AM
Similar request here:

https://connect.microsoft.com/SQLServer/feedback/details/471287/extend-function-library-and-allow-user-defined-functions-for-ssis-derived-column-transformation#

Seriously this is a very critical component. Especially when you consider how easily the competing solutions (Oracle Warehouse Builder, etc) provide for it.

Posted by richard.king on 10/20/2008 at 3:18 PM
I notice that this issue's status is closed as of 7/21/2007, but ask that you re-open it. Although this time around, I had to abandon SSIS in favor of Java, I would like to see ability to extend the Expression language (or at a minimum be able to develop functions called within it).

This will not just lead to faster development, it will lead to possible development. Thank you!
Posted by Duane Douglas on 10/19/2008 at 11:10 PM
please do everything possible to get it into the next release. thanks.
Posted by Duane Douglas on 10/19/2008 at 10:47 PM
please do everything possible to get it into the next release. thanks.
Posted by data-dude on 6/18/2008 at 10:04 AM
Yes, this would be very useful. Please add to a future release!
Posted by Rafael Salas on 3/24/2008 at 6:44 AM
I think this is a great suggestion; and even when is not going to make it for 2008 version; at least please keep this suggestion open to be consider for the next release.
Posted by Microsoft on 7/2/2007 at 6:32 PM
Thanks for reporting this issue, unfortunately we are not able to implement your suggestions (or fixes) in the Katmai timeframe.
Posted by Microsoft on 7/21/2006 at 10:52 AM
Thank you for using SQL Server Integration Services.
This is a very good suggestion and not uncommon, to have some way to use global code or variables across the control/data flows. We are investigating how best to accomplish this for a future release.
Thank you.
Sign in to post a workaround.