Execute T-SQL Statement using Parameter Values

Question

Execute T-SQL Statement using Parameter Values

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 1

There is always only one record in the ReportingPeriod table. I removed the Parameter Mappings and now get this error:

[Execute SQL Task] Error: Executing the query "Select ? = CurrentReportMonth, ? = CurrentReportYe..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Step 1:

Parameter Mapping:

Result Set:

Phil Parkin SSC Guru Points: 246965 More actions · Answer 2

VA123 - Friday, March 10, 2017 6:43 AM
There is always only one record in the ReportingPeriod table. I removed the Parameter Mappings and now get this error:
[Execute SQL Task] Error: Executing the query "Select ? = CurrentReportMonth, ? = CurrentReportYe..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Step 1:
Parameter Mapping:
Result Set:

You did not change the SQL as I requested.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 3

Phil Parkin - Friday, March 10, 2017 6:48 AM
VA123 - Friday, March 10, 2017 6:43 AM
There is always only one record in the ReportingPeriod table. I removed the Parameter Mappings and now get this error:
[Execute SQL Task] Error: Executing the query "Select ? = CurrentReportMonth, ? = CurrentReportYe..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Step 1:
Parameter Mapping:
Result Set:
You did not change the SQL as I requested.

That was it Phil! I needed 'Select Top(1)...' Thank you all for your time with this.
Phil, A related question: Why do I not see the variable values of 2017 and 3 for var_fy and var_period in the Variables window during debugging mode? The 'Delete' step worked. See below:

Phil Parkin SSC Guru Points: 246965 More actions · Answer 4

You are not looking at the correct window. The values in the Variables window do not change.

There is another window, called locals or local variables (I'm not in a position to check right now), which is available to you during a debug session. See whether you can find it, but if not, post back and I will double check later.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin