Assume that you use Microsoft SQL Server Integration Services (SSIS) packages in Microsoft SQL Server 2016 and 2017. You have a SSIS package that contains the Execute SQL task that uses parameterized SQL statements in Connection Manager to copy connection string details from a project parameter to a user variable.
When another task whose connection string is dynamically populated from the user variable, the task fails. Additionally, you receive error messages that resembles the following:
[Analysis Services Execute DDL Task] Error: A connection cannot be made. Ensure that the server is running.
[Analysis Services Execute DDL Task] Error: Execution of DDL failed.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.