Referencing Other Assemblies in Scripting Solutions

Referencing Other Assemblies in Scr...

Community Content

In this section

Statistics Annotations (1)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (October 2009)

Referencing Other Assemblies in Scripting Solutions

The Microsoft .NET Framework class library provides the script developer with a powerful set of tools for implementing custom functionality in Integration Services packages. The Script task and the Script component can also use custom managed assemblies.

Note:
To enable your packages to use the objects and methods from a Web service, use the Add Web Reference command available in Microsoft Visual Studio Tools for Applications (VSTA). In earlier versions of Integration Services, you had to generate a proxy class to use a Web service.

Using a Managed Assembly

For Integration Services to find a managed assembly at design time, you must do the following steps:

Store the managed assembly in any folder on your computer.

Note:
In earlier versions of Integration Services, you could only add a reference to a managed assembly that was stored in the %windir%\Microsoft.NET\Framework\vx.x.xxxxx folder or the %ProgramFiles%\Microsoft SQL Server\100\SDK\Assemblies folder.

Add a reference to the managed assembly.
To add the reference, in VSTA, in the Add Reference dialog box, on the Browse tab, locate and add the managed assembly.

For Integration Services to find the managed assembly at run time, you must do the following steps:

Sign the managed assembly with a strong name.
Install the assembly in the global assembly cache on the computer on which the package is run.
For more information, see Building, Deploying, and Debugging Custom Objects.

Using the Microsoft .NET Framework Class Library

The Script task and the Script component can take advantage of all the other objects and functionality exposed by the .NET Framework class library. For example, by using the .NET Framework, you can retrieve information about your environment and interact with the computer that is running the package.

This list describes several of the more frequently used .NET Framework classes:

System.Data Contains the ADO.NET architecture.
System.IO Provides an interface to the file system and streams.
System.Windows.Forms Provides form creation.
System.Text.RegularExpressions Provides classes for working with regular expressions.
System.Environment Returns information about the local computer, the current user, and computer and user settings.
System.Net Provides network communications.
System.DirectoryServices Exposes Active Directory.
System.Drawing Provides extensive image manipulation libraries.
System.Threading Enables multithreaded programming.

For more information about the .NET Framework, see the MSDN Library.

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Concepts

Extending Packages with Scripting

Help and Information

Getting SQL Server 2008 Assistance

Tags

: Add a tag

Community Content

Add new content

Annotations

add Microsoft.Scripting.Runtime refernece in VSA

z001 ... Thomas Lee | Edit | Show History

there is no browse tab in add reference dialog box, how to add Microsoft.Scripting.Runtime reference

[tfl - 07 10 09] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&