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.
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
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
No comments:
Post a Comment