Batch File Script to deploy SSIS packages via DTUTIL command

The below script helps to deploy SSIS packages to MSDB folder in a server:

@Echo Off

Echo.

Echo.

Echo SSIS Package Installation Script

Echo.

if %1a == a goto Error

if %2a == a goto Error

if %3a == a goto Error

Echo.

Echo.

Echo Deployment Server: %1

Echo -----------------------------------------------------

Echo --This will delete any %3 data mart files

Echo --on the server, and reinstall from the local machine

Echo -----------------------------------------------------

Pause

REM Goto Out

REM Remove Existing files and directory on Server

for %%f in (%2"\*.dtsx") do (

Echo Now Removing: %%~nf

dtutil /Q /SourceS %1 /SQL "\%3\\%%~nf" /Del

)

dtutil /Q /SourceS %1 /FDe "SQL;\;%3"

:Create

Echo.

Echo Preparing to create folder

Echo.

pause

REM Create the Directory

dtutil /Q /SourceS %1 /FC "SQL;\;%3"

if errorlevel 1 goto End

Echo.

Echo Preparing to Copy Files to Server

Echo.

pause

:Out

REM copy the SSIS Packages to the server

for %%f in (%2"\*.dtsx") do (

Echo Now Copying: %%~nf

dtutil /Q /DestS %1 /Fi "%%f" /C "SQL;\%3\\%%~nf"

)

Echo.

Echo.

Echo Installation Complete!

Echo.

Echo.

Pause

Goto End

:Error

Echo.

Echo.

Echo Missing Servername!

Echo Syntax: Deploy SSIS Packages [servername] [Source File Path] [MSDB Deploy Folder]

Echo.

Echo.

Pause

:End

1. Copy the above code and crete a bat file (e.g., DeploySSIS).

2. Open Command Prompt and navigate to the batch file folder

3. Execute the command DeploySSIS.bat [SERVERNAME] [FILEPATH] [MSDB Sub-Folder]