posted on Thursday, July 07, 2005 3:35 AM by Knight_Reign

Adding references to assemblies in the script task

There is a limitation with the VSA architecture (VSA is Visual Studio for Applications) that makes it necessary to move assemblies to a certain folder in order to reference them in the script task. It's not sufficient to add a reference in the environment. You must move the assembly by copying it.

  1. Copy the assembly from the location where you find it to %windir%\Microsoft.net\framework\v2.0.xxxxx
  2. Add a reference in the script task editor under the Project | Add References menu.
  3. In the script, add the Imports AssemblyName statement
  4. Make sure the assembly is in the GAC

You should now be able to use the assembly methods in your script task.

Thanks,

Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden

Comments