In this blog,
we will learn about the different ways in which we can execute or run the SSIS
package.
- Execute the SSIS Package from the command prompt by using DTExec.exe command
- Execute the SSIS package in SQL Server Business Intelligence Development studio – BIDS
1. DTExec.exe command:
SQL Server includes the command line
tool DTEXEC.EXE which can be used to execute an SSIS package. DTEXEC can
be run from a Command Prompt or from a batch (.BAT) file
C:\Users\rtiwari>DTEXEC
/FILE {Location of SSIS package}
If you have
configuration file for this ssis package
C:\Users\rtiwari>DTEXEC
/FILE {Location of SSIS Package } /CONFIGFILE {Location of configuration file}
Here is an example to run ETL SSIS
package with configuration file
C:\Users\rtiwari>DTEXEC /FILE C:\\Sample\\ETL_Extract.dtsx /CONFIGFILE C:\\Sample\\ETLConnectionStrings.dtsConfig
2. Execute the
SSIS package in SQL Server Business Intelligence Development studio:
In visual
studio to execute the SSIS package, right click
the package within Solution Explorer and select Execute Package option from the
drop down menu as shown in the below.
No comments:
Post a Comment