Hello
I have some common functions that i use in several script tasks. How du i store a function globaly so that i can use it from different projects and still only have to edit it one place
How to Reuse functions in script tasks ?
Hot Topic
- 2000/2005 Mixed Replication
- How to backup a database to a network drive
- text box sending large amounts of text to next page Microsoft please help
- How to: Query Time only?
- a newbie question on SQL database use
- move report server to new machine
- Build Question
- Moving log file on Error detected...
- About Login Account
- SqlServer2005 can support merge replication with SqlCe2.0??
SQL Server
- Parameter Mapping in an Execute SQL Task
- readxml doesnt work :(
- Trouble connecting with bcp
- CTP June Dev.Edition:TCP/IP protocol is disabled at default
- MySQL function equivalent
- SQL Server 2005 can't be added Active Directory, but the documentation says it can.
- SRS Dynamically Generating Barcode at runtime.
- How to get detailed info of views?
- Excel pivot table. Any language you like as long as its US English
- Restored Database/Diagrams Support/SQL-Server 2005
How to Reuse functions in script tasks ?
Chuck S.
Correct.
I am not able to think of any other way to do the same.
Because each script task is different Identity(different project), if you create a function into one ...the other script task will not be aware of it.
How do you share a global function b/w two different projects
Thanks
Dharmbir
Mr.Walker
I think one way is to create a dll of the function and import in each of your script tasks. To Import the dll into each of the script you need to place the dll into <root>\Windows\Microsoft .Net\Framework\<Latest Version> and gac it.
I think this will help...
Thanks
Dharmbir
mms02
You don't have to import in each of your script...
once u do changes copy to the <root>\microsoft.net\.... folder again and just gac it...
It should work
Mike Mayer