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).
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.
801 total views, 2 views today