Execute package task in SSIS

Hello friends, in my last article we saw how to deploy a SSIS package, in this article we will learn how to execute a SSIS package using “Execute package task”. Lets see how to implement “Execute package task”.

Prerequisites : Before implementing the “Execute package task” we should have previously deployed a SSIS task.We will drag and drop “Execute package task” in to control flow region(As shown below).

To configure the “Execute package task”, we will right click on it and click on “Edit” menu that will bring a new screen to us(As shown below).

We need to define the package location in the screen shown above, since our package is stored in MSDB database, hence our package location would be SQL Server. Now we need to define the connection as well, to define the connection we will click on connection combo box and select the “MSDB” database while defining the connection(since our package is stored in MSDB database).

After defining the connection, we will select the package name, to select the package name we will click on the button(encircled with red color) as shown below.

Once we click on the square button, a new window will appear as shown below.

Under packages node our deployed package is being shown, we will select the “Transferobjects” package and click on “OK” button to save the settings. In the “Password” field , we enter the password for encrypted packages, since our package is not encrypted one , hence we are not going to touch that field.

ExecuteoutofProcess: If we set this field’s value “True”, our package will be executed as a separate process. By default its value is “False”. After configuring all the fields, we will click on “OK” button to save the settings. Now we are done with our package. Lets execute it by pressing “F5” key and see the results.

Green color of package indicates that our package ran successfully. In this article we have executed a package which was stored into “MSDB” database, similarly we can execute a package stored in file system. You can explore that option with yourself and please let me know if you face any challenge.

I hope you will find this article useful, I will be back with another SSIS topic next time, till then take care.