Once we develop and deployed SSIS project to Integration Services Catalog, configured environment/environments variables and given reference for environments. We need to unit test by executing deployed packages, whether our environments variables inside environments are consuming or not.
We can execute deployed packages by different ways, now I will explain how to execute deployed packages in two ways
A.Execute SSIS package in Integration Services Catalog
To execute SSIS package in Integration Services Catalog, we need to browse and select which package we need to execute and Right click on it and choose Execute button, then it will lunch you another window, then we need to click on check box Environments and choose .\Dev from drop down
Once we click on Ok button, it will lunch you another window like below. Windows ask us to do we want to report the real execution report, if we click on Yes, it will show us the execution status else it will execute in backend but not show the execution status
B. Execute SSIS package using SQL Job
We can execute SSIS package by using SQL Job also, to configure SQL Job, we need to right click on SQL Job Agent /Job and choose New Job
Then it will lunch you another window , here we need to click on New button which is available in Left bottom corner . Here it will open Step Wizard, then we need to give proper Step name and choose Type as SQL Server Integration Service package as need to execute SSIS package. Below we can see two tabs, Package and Configurations.
In Package Tab,Package Source should be SSIS Catalog as we deployed our SSIS packages in Catalog. Give server name in Server and enter your credentials. Click on Packages (highlighted button next to text box) and browse then SSIS package which ever package we need to execute and Click on OK
And click on Configurations Tab and click on Check box of Environment and choose as .\Dev
And click on OK
Then we will see created Job in SQL Job Agent. Now we can run this Job ,by right click on Job and choose Start Job at step 1 and Ok .
We can execute deployed packages by different ways, now I will explain how to execute deployed packages in two ways
A. Execute SSIS package in Integration Services Catalog
B. Execute SSIS package using SQL Job
A.Execute SSIS package in Integration Services Catalog
To execute SSIS package in Integration Services Catalog, we need to browse and select which package we need to execute and Right click on it and choose Execute button, then it will lunch you another window, then we need to click on check box Environments and choose .\Dev from drop down
Once we click on Ok button, it will lunch you another window like below. Windows ask us to do we want to report the real execution report, if we click on Yes, it will show us the execution status else it will execute in backend but not show the execution status
B. Execute SSIS package using SQL Job
We can execute SSIS package by using SQL Job also, to configure SQL Job, we need to right click on SQL Job Agent /Job and choose New Job
Then it will lunch you another window, here we need to give Job Name and then click on Steps
Then it will lunch you another window , here we need to click on New button which is available in Left bottom corner . Here it will open Step Wizard, then we need to give proper Step name and choose Type as SQL Server Integration Service package as need to execute SSIS package. Below we can see two tabs, Package and Configurations.
In Package Tab,Package Source should be SSIS Catalog as we deployed our SSIS packages in Catalog. Give server name in Server and enter your credentials. Click on Packages (highlighted button next to text box) and browse then SSIS package which ever package we need to execute and Click on OK
And click on Configurations Tab and click on Check box of Environment and choose as .\Dev
And click on OK
Then we will see created Job in SQL Job Agent. Now we can run this Job ,by right click on Job and choose Start Job at step 1 and Ok .
Kiran Reddy A
Kiran has been a part of the IT industry for more than six years and Involved in many MSBI projects and product development with extensive usage of ETL and Reporting tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS) and T-SQL
Get Free Email Updates to your Inbox!
