Monday, December 21, 2020

Kingswaysoft - Deploying SSIS Package - User cannot login error even though the package runs correctly in Visual Studi

https://docs.microsoft.com/en-us/troubleshoot/sql/integration-services/ssis-package-doesnt-run-when-called-job-step


Solution:

When deploying the project, choose "EncryptWithPassword" as the protectionlevel.

On Project>Properties - Choose "Encrypt all data with Password"

On Package>Double click to enter>Properties - Choose "Encrypt all data with Password"

Enter password in PackagePassword field

Debug>Rebuild Solution

No comments:

Post a Comment