h1

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.

image

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. 

image

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.

image

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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: