Friday, September 27, 2019

SSIS: Different way to execute SSIS Package

In this blog, we will learn about the different ways in which we can execute or run the SSIS package.

  1. Execute the SSIS Package from the command prompt by using DTExec.exe command 
  2. 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.

execute the SSIS package



No comments:

SQL Server - Identify unused indexes

 In this blog, we learn about the index usage information (SYS.DM_DB_INDEX_USAGE_STATS) and analyze the index usage data (USER_SEEKS, USER_S...