Technical Article

Import Multiple Packages to SSIS server

,

We cannot import multiple packages on the SSIS server. So, loading 100 packageS from  file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the DTUTIL utility.

This script is the batch file I used to load the multiple packages on an SSIS server. You need to execute this Batch file on the server where SSIS services are installed.

 

cd C:Package_loacation

FOR IN (*.dtsx) DO DTUTIL /FILE C:Package_loacation /COPY SQL;Folder_location_SSIS_serverni /QUIET

Rate

Share

Share

Rate