Execute SSIS Package using Windows command line (dtexec)

Deploy your ssis package to SSIS, you can deploy your dtsx package to SSIS Catalog using this step

• open Integration Service Catalog

• Right click on Projects and select import packages

• follow the wizard and make sure you select your package file

• after successfully imported to SSIS catalog, refresh projects directory

• execute the package file in Integration service catalog using this command (matching the SQL Server version with your installed version)

C:\"Program Files"\"Microsoft SQL Server"\130\DTS\Binn\dtexec.exe /ISServer "\SSISDB\MySSIS\PumpData\Package.dtsx" /Server "localhost"