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 Continue Reading

TSQL pattern matching as part of a table join

OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:

To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning Continue Reading