Problem: How to deploy SSIS
Packages on to a SQL Server or to package store.?
Solution: Deploy SSIS Packages to
Integration Services Catalog.
In some cases, you may want to execute the package from a
SQL Server Integration Catalog, to do that we need to deploy the packages from
the Solution of SSIS Packages.
To deploy SQL Server Integration Services
packages, you use the Package Installation Wizard. By using this wizard,
you can deploy packages to one of two locations:
·
To an instance of SQL Server.
·
To the file system.
The procedures in this topic describe how to deploy packages to
each of these locations.
Example:
In this article, I am going to show we can deploy packages
to Integration Services Catalog DB.
Step 0:
Create a new Catalog Folder called SSIS DB on Integration Services Catalog.
Step 1: Launch
Visual Studio and Go to SSIS Solution folder, build the solution to output to
bin folder and then right click on the solution file to deploy the project. This
will launch a wizard to deploy.
Step 2: In
this wizard, you are asked to configure the source details like server name and
path to save the catalog.
Step 3: Click
ok to review and it will take to final screen of deployment.
Step 4:
Confirm the Packages exist on the Catalog.
\
\
Results:
Right click on the package folder to execute the packages.
0 comments:
Post a Comment