I have read several articles about deploying SSIS packages.  Most focus on using the deployment wizard or simply copying the files and their dependent properties onto the server.  For companies with a small number of SSIS packages the later appears to be the method of choice.  Recently, I was asked if there was a way to accomplish this without leaving Business Intelligence Development Studio (BIDS).

To deploy a package from BIDS complete the following steps:

1.        Open your SSIS package in BIDS:

2.     Once the package is opened, click in the empty space of the Control Flow tab view.

3.    Go to File->Save Copy of <Package Name> As…

Then a dialogue box will appear:

Type your server name in the Server drop down list and type the Package path, prefixing it with a forward slash (/). 

4.  Next choose your Package protection level and click OK twice.

Finally, connect to the Integration Server to verify that the package has been deployed.

This method may not be practical if you have several packages and many environments.  However, for a small IT shop that only has a small number of SSIS packages this maybe a good approach.  

If you have any questions or comments regarding this topic, feel free to email me at pleblanc@pragmaticworks.com.