What is the problem you are actually experiencing? What errors are you getting? What formats are causing the problem?

Use an expression based on the parameter to set the Hidden property of the subreport.

IIF(Parameters.ShowSub.Value = "True", False, True)

How is the performance issue manifesting itself? With SQL Server 2008 ad hoc query plans also get cached, so are you seeing plans being more recompiles because the number...

Hey, that's a nice tip....

Can you post the table structures and some sample data? Please see the links in my signature for advice on posting this information.

Thanks Bruce. Means a lot coming from you. I've definitely noticed the quality of your responses. You are definitely an asset to the community. Glad you...

Thanks Bob, I'll give it a shot on Monday.

RBarryYoung (2/6/2009)

---

Nice article, Andy. I tried this on SS2k8 and one thing that surprised me was a number of small details that changed and threw me first: Like...

Sure. I do "glue" tables ...

Yes. At least full weekly. Particularly master and msdb. master has the information about your user databases, logins, etc... and msdb stores all your maintenance plans, jobs, schedules,...

Since I don't really know what you need to do and why I can't really make any suggestions. If you have SQL Server other than express edition you have...

Just found this post duplicate here with more answers so please post there.

polaiah,

Please do not post duplicates as I, and possibly others, just wasted time looking at both.

Thanks,

I think I recall having seen an issue like this before. I'd suggest deleting the OLEDB Destination and recreating it. I think the package caches the datatype information...

This is causing the error:

EXEC SP_TD_GEN_NEXTID 'GN', 'TD_SURVEY_RESULTS', 'nResultID', @pin_nResultID OUT

How is this code working? When is your id value being incremented? You need to code something that...

What are you using to generate the results (SSMS, Reporting Services, A custom application)?