Deploying a single SSIS packages from BIDS

October 20, 2011

In my previous posts I detailed the process for using a Deployment Manifest to deploy SSIS packages as well as using the Import package option from Management Studio while logged into the SSIS Server.  In this post I’ll walk you through the steps of deploying a single package right from the BIDS environment.

Lets start by opening up a package inside of BIDS.


Once you have created the package and it is ready for deployment click anywhere in the design pane and then File-> Save Copy of <Package Name> as. 


This will launch a window for deploying the packages.  From this point forward it is pretty much the same as Importing the package into SSSIS.

From the new menu screen you must first select where the package you want to import is located, either SQL Server, File System or SSIS Package Store.


If you are using SQL Server you must next tell it the server name and the type of authentication to use (and username and password if you use SQL Server Authentication), then specify the package in SQL Server. If you are using the file system just specify the package path. You can also set the package protection level here as well.

Click ok and the package has now been deployed. Just as in the Import process please note that this will only deploy the package, so if you have any package configurations you must deploy those separately.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: