Deploying Packages In SQL Server Integration Services (SSIS) 2012

• Jobs in SQL Server

On General Tab enter your job name.

On Step tab create a new job step and fill the details as shown below.



Fill below details:

Step Type as SQL Server Integration Service Package,
Package Source as SSIS catalog,
Enter Server Name,

Select your SSIS package via a browse button and click on OK.

On successful creation your job will get listed in the Job activity monitor.



Now run your job and your package will begin the execution.

Another way to execute the package is to right click on a package and select "Execute".



This will open an Execute package window where you can view your parameters, "Connection Manager" and other advanced options as shown below.



Click on OK button to begin the execution. On successful execution, the report gets generated and you’ll find the details of the execution in that report as shown below.



This report tells you the execution information like Execution duration, its start time, end time.

Also, you can check how much time taken by each task under "Execution Overview" section.



Our package executed successfully and we’ve taken a backup of system databases and backup file saved under C:\Backup\ directory, for each database backup task created separate directory and stored their backup file in the same as in the following two images:




With this article we’ve successfully deployed our package in SQL Server Integration Catalog.

Conclusion

In this article we’ve seen how to enable Integration Services Catalog and we also learned the steps to deploy the package into that catalog. Further, we have seen how we can run those packages, i.e. via job and direct execute method. Next we executed our package to perform the backup operation and also we’ve generated report for the same.

I hope this and other previous articles help you in learning SSIS. This is not the end; still we’ve lots to learn in this series. In our next article we’ll explore other tasks of SSIS 2012, till then keep learning and keep sharing….

If you’ve any suggestions or if you find any mistake in the article, please feel free to share via your valuable comments and feedback. I’ll try my best to implement those in my next article.