The simplest way to create an installer for your custom SSIS extension is by using a Setup Project in Visual Studio. Here are the steps we take when we’re creating installers for our Codeplex projects.
1. In Visual Studio, create a new Setup Project – File -> New Project…
2. Under Other Project Types | Setup and Deployment, select Setup Project
3. Delete User’s Desktop and User’s Project Menus folders from File System (Setup) screen
4. On Application Folder, set the DefaultLocation property to the root DTS directory:
Ex. [ProgramFilesFolder]Microsoft SQL Server\100\DTS
5. Right click on the Application Folder and add the sub folder you need to put your sample in (ie. Tasks, PipelineComponents, Connections)
6. Right click on the new folder, and add “Project Output” to the folder to place binaries from your sample.
7. If you need to place files in the GAC, right click on File System on Target Machine -> Add Special Folder -> Global Assembly Cache Folder
It will now show up as an additional folder, and you can add project output to it.
8. Exclude all dependencies by highlighting all of the files under the Detected Dependencies Folder, and selecting Exclude
9. If you’d like to add a readme .rtf file, place it in the Application Folder.
10. You’ll need to edit the UI pages to display a readme after the install. Right click on the Setup project, View -> User Interface to bring up the UI page.
11. For both the Install and Administrative Install, right click on End and select Add Dialog. Select the Read Me dialog. Drag the “Read Me” page to be above the “Finished” page.
12. Set the ReadmeFile property to your readme file.