External assembly to be used by the script component ?
I am new to SSIS and after a few days of writing packages, I find myself duplicating code in the script component of several packages. is there anyway to link script components to an external assembly similarly to doing it in SSIS where several reports can
link to an external assembly to perform various formatting tasks ?
Thanks
Zeev
August 27th, 2011 12:35pm
See this blogpost:
http://microsoft-ssis.blogspot.com/2011/05/referencing-custom-assembly-inside.html
Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2011 12:44pm
Yes it is possible you have to make the assembly a strongly named one and then add it to GAC. Then you acan add a reference of that assembly using project explorer in the Devenv window that opens after pressing design script
http://support.microsoft.com/kb/315682
--------------------------------------------------------
Surender Singh Bhadauria
August 27th, 2011 12:44pm