How to Use a Dynamic Connection String During SSIS Package Validation in Visual Studio 2017 Package Deployment Model?

Jerry_2424 0 Reputation points
2024-09-05T13:47:00.2666667+00:00

Is there any event handler or task that can dynamically change the connection during the validation phase of a package when executed through the Execute Package utility? I have two variables in my configuration file, DriverName1 and DriverName2. I want the connections to be updated during the validation phase itself so that the package does not give errors due to missing connections or drivers at validation time. I do not want to set DelayValidation = True. I need an option that will ensure the task passes validation. This is an urgent requirement for a client. I have searched Google but couldn't find anything related. If anyone knows, please help. This is an urgent client issue. I will send the solution by tomorrow end of day.

I want everything to work correctly during package validation as well. I have already implemented code to change the connection string at runtime, but it is not working during validation.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,042 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,564 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,116 Reputation points
    2024-09-06T06:09:33.6333333+00:00

    Hi @Jerry_2424，

    It is a bit hard to Use a Dynamic Connection String During SSIS Package Validation.

    You may create another package with the DriverName2 connection and set the package as same as the DriverName1 package and then use Execute Package Utility to run the two packages.

    You can use 'completion' between the two Execute Package task.

    User's image

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.