‘Could not create a managed connection manager’ Error Message on SSISDB .dtsx Package Execution

SQL Server Integration Services (SSIS) package execution can always throw up a few spanners, particularly when it comes to the task of deploying packages out to a SQL Server SSISDB catalog - principally, a specialised database for the storage of .dtsx packages, execution settings and other handy profile info to assist with automation. Problems can [...]

Resolving “Failed to decrypt an encrypted XML node because the password was not specified or not correct” Error (SSIS)

If you are looking at automating the execution of SQL Server Integration Services .dtsx packages, then there are a few options at your disposal. The recommended and most streamlined route is to utilise the SSIDB catalog and deploy your packages to the catalog from within Visual Studio. This gives you additional flexibility if, when working [...]

Resolving GUID SSIS Import Error “The value could not be converted because of a potential loss of data”

Perhaps one of the most fiendish aspects of working with SQL Server Integration Services (SSIS) is the inevitable data transformation/conversion issues that get thrown up, even as part of relatively simplistic Extract, Transform & Load (ETL) packages. It doesn't help as well if, having come from a strictly T-SQL focused background, you are then having [...]