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.
No comments:
Post a Comment