Deploying the Class Library to SSIS
To enable SSIS to use your class library, you must sign
the assembly, copy it from SharePointServices\bin\
Debug\SharePointServices.dll to C:\Windows\
Microsoft.NET\Framework\v2.0.50727, and install the
assembly to the Global Assembly Cache (GAC).
If you aren't familiar with the process for signing an
assembly, follow these steps:
1. Right click on your project.
2. Select Properties.
3. Select the "Signing" tab.
4. Select <new...> from the "Choose a strong name
key file" dropdown.</new...>
5. Enter the name of the project in the "Create Strong
Name Key" dialog box (see Figure 3).
6. Uncheck "Protect my key file with a password."
7. Click OK.
8. Compile the project.
Then, to install the Assembly to the GAC:
1. Open up a "Visual Studio 2005 Command Prompt"
from the start menu.
2. Change to the directory where you copied the
assembly (cd "C:\Windows\Microsoft.NET\
3. Install it by executing the command:
gacutil --i SharePointServices.dll
Now when you open up a script task in SSIS you can
add a reference to SharePointServices. If you make a
change to the file you'll need re-copy the changed file
and reinstall it to the GAC.
Set Up SSIS for Success
You're now ready to create an SSIS package to migrate
data. To do this, open Visual Studio and create a new
project, selecting the "Integration Services Project" tem-
plate that you'll find under "Business Intelligence
Putting SharePoint to Work for You, an Internet.com Developer eBook. Copyright 2008, Jupitermedia Corp.
Putting SharePoint to Work for You
Figure 2: Adding the Reference: Use this dialog
to add a reference to a Web service.
Figure 3: Creating a Strong Key: Enter the project
name in the Create Strong Name Key dialog.
Figure 4: Integration Services Project: The
Integration Services Project template option appears
only after you've installed SSIS.