SSIS

To make an installation package for a custom SSIS component the .dll(s) that make up the component must be installed into two places:

1. For design time it needs to be installed in the SQL Server's pipeline components folder C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents
2. For runtime it needs to be installed in the GAC

All your setup package has to do is install the .dll(s) into both of these places and you are ready to rock n' roll. This micro-howto doesn't cover aspects of the GAC (like signing code) or developing an SSIS component, for those topics I would recommend www.sqlis.com. Read on for notes on creating an installation package.