Deploying Multiple package from one Location to SQL server

Note:"dtutil.exe" application which is installed by default with SQL

Server installation.eg: C:\ProgramFiles\Microsoft SQL Server\110\DTS\Binn\dtutil.exe)

Main steps are as follows:

Hold+Right click on Location , desired path will appear in the command prompt

/Destserver :servername

/Foldername in SSIs : In our case Staging

for %I in (*.dtsx) means searching for all the SSIS packages

dtutil /File means invoking the dtutil tool

--staging/%~nI" : staging is the folder name and /%~nI is the continue of

sequence SSIS package from the Location folder

for %I in (*.dtsx) do dtutil /FILE "%I" /COPY SQL;"/staging/%~nI" /DESTSERVER localhost.

Reference :http://sqlserverzest.com/2013/11/04/sql-server-deploying-multiple-ssis-packages-into-sql-server-using-command-prompt-utility-dtutil/