SQL
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 MoreTSQL 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:
|
1 2 3 4 5 6 |
SELECT DC.LastName, DC.FirstName, FIS.TotalProductCost FROM FactInternetSales FIS INNER JOIN DimCustomer DC ON FIS.CustomerKey = DC.CustomerKey |
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 the LastName and FirstName and…
Read MoreSQL Server Table Designer can’t save changes
I come across this warning/error message every time I do a fresh install of SQL Server on my laptop and despite having set this option back more times than I care to remember, I end up spending a few minutes looking for the setting in the Management Studio options. Figure: Warning saving changes would result…
Read MoreNeed to search strings inside your SQL Objects? Try this utility
While performing a migration from SQL Server 2000 to SQL Server 2014 (wow what a big jump), I needed to find all stored procedures that made a call to an extended stored procedure that was being replaced with functionality that is baked into more recent versions. So what to do? Stack Overflow had a few good suggestions,…
Read More