Repository Server means the SSIS SQL Server where you have saved your SSIS packages.
- You can specify the SSIS SQL Server where your packages are located. It defaults to the local default instance. Unfortunately the GUI to execute doesn't support that parameter at this time.
/isDbServer:<string> SQL Servers where SSIS packages are stored. Default value:'localhost' (short form /i)
/isDbUser:<string> SQL Server user that has access to stored SSIS packages (short form /iu)
/isDbPwd:<string> SQL Server password for getting access to stored SSIS packages (short form /ip)
- The SSIS Catalog doesn't support a path. The path is a location on the file system where you have saved your packages.
- As all the packages I have built are set to "DontSaveSensitive", I've never encountered the issue with password encrypted packages.
I'll copy this to some work items to address the following:
a. GUI doesn't support setting SSIS Catalog Servers
b. There is no support for encrypted packages.