DIFFERENT WAYS TO EXECUTE THE PACKAGE

Below are the multiple ways to Execute a package

1. Using the Execute Package Utility (DTEXECUI.EXE) graphical interface one can execute an SSIS package that is stored in a File System, SQL Server or an SSIS Package Store.

DTEXECUI  provides a user interface that can be used to specify the various options to be set when executing an SSIS package.  You can start DTEXECUI by double-clicking on an SSIS package file (.dtsx).  You can also start DTEXECUI from a Command Prompt then specify the package to execute.

2. Using the DTEXEC.EXE command line utility one can execute an SSIS package that is stored in a File System, SQL Server or an SSIS Package Store. The syntax to execute a SSIS package which is stored in a File System is shown below.

DTEXEC.EXE /F "C:\BulkInsert\BulkInsertTask.dtsx"

 

3. Test the SSIS package execution by running the package from BIDS:

-In Solution Explorer, right click the SSIS project folder that contains the package which you want to run and then click properties.

- In the SSIS Property Pages dialog box, select Build option under the Configuration Properties node and in the right side panel, provide the folder location where you want the SSIS package to be deployed within the OutputPath. Click OK to save the changes in the property page.

-Right click the package within Solution Explorer and select Execute Package option from the drop down menu 

4. Sql Server Agent:
Drill down to the SQL Server Agent node in the Object Explorer.  Right click on the Jobs node and select New Job from the popup menu.

The first step to setting up the proxy is to create a credential (alternatively you could use an existing credential).  Navigate to Security then Credentials in SSMS Object Explorer and right click to create a new credential.

Navigate to SQL Server Agent then Proxies in SSMS Object Explorer and right click to create a new proxy.

LABEL: SSIS INTERVIEW QUESTIONS