Execute Package Utility Pass variables to package

Question

Hi folks,

I have a DTSX, created on Visual Studio, with multiple package variables, I already imported it on SSIS.

For testing, I selected an Execute Package Utility. I was able to change the connection string without any problem. Now I need to change a variable definition. I tried adding the property "\Package.Variables[Tabla].Value" on Set Values tab. Does not appear any error but the new value is not using during the execution.

What I'm doing wrong? Regards,

Answer 1

Hi @MariaBD ,

Please check if you set the variable value correctly in Execute Package Utility.

Hope the following pictures will be helpful:

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?