Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2007-11-07 : 09:19:53
|
| I need to write SSIS package with 5 script task. I have one function which need to be called from each SSIS one by one. I wrote the that function at first SSIS task. For example:Public Function Add() As IntegerDim i, j As Integeri = 10j = 20Return (i + j)End Functionand I can call this function inside 1st SSIS task but how can I call this function on rest of 4 script task?ThanksSanjeev |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-07 : 09:31:31
|
| moved from script library_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-07 : 16:47:22
|
| haven't seen this done in ssis but in dts this was done by creating a GLOBAL activex task that was diabled, then using alter properties to concatenate the functions from GLOBAL with the script already in the activex task that you want to use a global function from. you should be able to accomplish the same thing in ssis, but someone out there may have a better solution. |
|
|
|
|
|
|
SSIS function calling problem