Sample Header Ad - 728x90

Installing SSIS package outside of SSIDB catalog

2 votes
1 answer
841 views
I'm trying to simplify deployment of a SSIS package to a remote server. At the moment, I have * Local Visual Studio SSDT and SSIS package that has 4 connection managers - **DEV** environment * Remote server with SQL, SSMS, and SSDT installed - **PROD** environment The easiest way to deploy SSIS package from local computer to the remote server is to * Create SSIDB catalog on the remote server * Perform Deploy from Visual Studio and point it to the catalog created on the remote server In this case everything works fine. In the meantime, some **remote servers may not be accessible from Visual Studio** directly, so I'm trying to precompile SSIS package on local computer, upload to the remote server and add it to SQL server job as a single file, like it's described in this article . The second screenshot in that article shows that I can choose Package Source = File System and specify a path to SSIS package file. **The issue** When I deploy SSIS package from Visual Studio to SSIDB catalog and create SQL server job using package in the catalog, it correctly shows 4 connection managers used by the package. When I create SQL server with manually uploaded SSIS package file, the tab Data Sources in SSMS shows empty list of connection managers. **Why in the second scenario, connection managers were not deployed with the package?**
Asked by Anonymous (143 rep)
Jan 26, 2021, 08:18 PM
Last activity: Apr 13, 2025, 09:06 PM