Execute stored procedure or SQL task from script.

[jasond22]

Hi
Ive been searching everywhere on how to do this, but with no luck.
Basically I have a SQL function that determines whether or not a row must be copied.
It takes 1 parameter and returns another.

Can I call this function from within my transformation script?

I tried adding the function to a 'Execute SQL Task' like this : 'Execute MyFunction ?' which seems to work fine (I will use global parameters for input and output) but how do I execute this SQL tasl from my script?

Any help will be greatly appreciated.

Thanks