Share via

Execute SQL Tasks upon executing clear local variable value in SSDT 15 for VS-2015

Abhijeet J. Patil 1 Reputation point
2021-01-28T12:12:03.943+00:00

I have SSDT package migrated from Win-7 desktop (SSDT-2012) to Win-10 Ent desktop (SSDT-2015 with VS-2015).

When I debug the SSDT package in SSDT-2015, one Execute SQL task, upon successful execution clears local variable values.

This Execute SQL task calls Stored Procedure in SQL Server DB with no input parameters and return string value.

Original SSIS package was in SQL Server BIDS 2008 R2 and works without any issue on Win-7 desktop. Post migration from SSIS 2008 R2 to SSDT 2012 it's giving this error.
Has anyone came across such weird behavior?
Can anyone expert please help me?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-01-29T02:37:14.933+00:00

    Hi @Abhijeet J. Patil ,

    When I debug the SSDT package in SSDT-2015, one Execute SQL task, upon successful execution clears local variable values.

    1. Could you please share the screenshots about Execute SQL Task and local variable?
    2. May I know how do you set the variable value?
      a. Passing value to variable through Execute SQL Task?
      b. Setting the expression in variable?
      61655-variable-expression.png
    3. We can set Breakpoints to view the variable value when the package is running.
      Please refer to SSIS - How To Watch Value Of Variables During Debugging In SSIS Package.

    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.