Yes I think more complex.  The item types are passed to the stored procedures as a parameter string like this: 'Plastic,Steel,Tree,Wood'  I insert the comma delimited string into a temp...

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,...

I set the result set to single row and completed the Result Set panel (attached).  This produced an error (also attached): Error: No result rowset is associated with the execution...

There is one row from cvuReportingPeriod.  See attachment from ManagementStudio.

One more screen shot.

Thank you all; however, this is still not working.  It appears the Period and FY variables never get populated.  I've attached screen shots of the steps.  Please have another look.

It appears the var_period and var_fy variables are never set in the first Execute SQL Task where I select period and FY from ReportingPeriod. table.

I'm struggling with getting this to work

1. Created two variables named var_fy and var_period
2. Created a Execute SQL Task to get the period and...

Gail, I failed to include an important piece of information in my original post. This SQL Server is running on a VM machine. The server admin group...

Thanks, Gail. I'll go talk to the server admin people and then report back to you what they discover.

The query for the drop-down parameter is probably returning a name for each row in the view or table. How about something like this: Select Distinct [Name] From [YourTable].

There are no indexes; there is no primary key. I expect to always select from the table using the month and year fields. FY is the year...

Thank you for your reply, Sean. This request is not due to a slow query. Both the reporting process and table are new. There are no current...