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/
When i run this script from an sql server job step, it raises an error. %~nI is not valid...
ReplyDeleteplease advise
I didn't test this through Agent jobs. Run through command prompt and ensure that you have SSIS Server running and follow the steps .
ReplyDelete