How do I load the Sample SSIS Components?

How do I load the Sample SSIS Components?

• bnn

  Marjorie,

  Firstly, you need to compile the project. Right-click on the project and select build. That will place the created assemply (i.e. a DLL file) into the debug folder of the project in the Visual Studio directory.

  In order to use it 2 things need to happen:

  1) It needs to be moved to %programfiles%Microsoft SQL Server/90/DTS/Tasks or %programfiles%Microsoft SQL Server/90/DTS/PipelineComponents depending on whether it is a task or a component (I'm guessing that CodePageConvert is a component but I'm only guessing)

  2) Add the DLL to the global assembly cache (GAC)

  You can automate these 2 steps as described here: http://blogs.conchango.com/jamiethomson/archive/2006/02/08/2772.aspx

  There is a caveat here - you won't be able to GAC the assembly unless it is strongly named. This is an encryption that must be applied to the assembly (I think). To strongly name your assembly right-click on the project and select "Properties". Go to the "Signing" tab and write "CodePageConvert.snk" in the strong-name-file box. After doing this your assembly will be strongly named and you will be able to GAC it.

  Once you've done all this your component is available for use. Right-click in the toolbox and select "Choose items...". From the dialog select the "Data Flow items" tab and your component should be available in there.

  So the steps are:

  1. Strongly name the assembly
  2. Add the post build event as explained in the link
  3. Build the project
  4. Select "Choose items..." from the toolbox etc...

  That should be it. I've written all the above from memory so it might not be exactly correct but it should be enough to be getting on with.

  -Jamie

  
  
  

• Ariel Kirsman

  One doesn't need full VS to build the projects - .NET framework includes msbuild.exe tool which shares the project format with VS and can build .csproj projects.
  
  But I think a deleveloper with some .NET experience (for .NET samples) is still required to be able to build and install the samples.
  
  

• AmyKutty

  The project is not visible in Visual Studio. Installing the .msi created a project folder in my Visual Studio directory but did not actually create a project. The only files I see are *.cs and *.csproj.
  

• Jessica Mamer

  Double click the csproj file, that is the C# Project File. You need to open the project (double-click) then build it as Jamie described above.
  
  

• cfjgrind

  When I double-click, it brings it into some sort of Visual Studio editor...and looks like html. There is not option anywhere on the menus or right-click drop down that says "build".
  

• jdarias

  Sounds like you do not have C# installed, in other words you only have Business Intelligence Development Studio, not full Visual Studio 2005 with development languages.

  You will need VS not just BIDS to compile the samples. It would be handy if MS could supply a compiled version for non-developers, but I guess the rational may well have been that most of the samples are there to illustrate development concepts and practices rather than being working components ready for real-world use, in fact the I'm sure they say they are explicitly not aimed at production systems, but that is no doubt a cover yourself clause. (If it is not production strength code, then why would we follow it as a guide for our own production components!)

  The difference in VS vs BIDS is explained a bit more and illustrated here-

  http://wiki.sqlis.com/default.aspx/SQLISWiki/BIDS.html

  
  
  
• How do I load the Sample SSIS Components?