SQL Server Reporting Services
SSIS Task: The SQL command requires a parameter named “@Param”, which is not found in the parameter mapping.
Time for a quick blog post on this error. This error has caught me out on more than one occasion, so much so that I’m writing this post now, grrrrr! So what happens? You’re creating an SSIS Task that includes an OLEDB source. The OLEDB source calls a Stored Procedure and you’re passing in some…
Read MoreReporting Services migration made easy with ReportSync
Recently I was given a task to move a custom application developed on top of SQL Server 2005 to SQL Server 2014 (yes a big jump!). One of the tasks was to move the reports over to the new server. The server was already built and an empty reporting services instance was available. I needed a way…
Read MoreAdding a new field to an SSRS Report and seeing #Error on preview
I don’t know how many times I’ve done this, the scenario goes something like this, your boss emails you asking for some new field to be added to a report. You spend quite a bit of time adding the necessary logic to the underlying dataset, everything looks great from SQL side of things. Next you update the…
Read More