Remember when you used to have to write your times tables out? You had to because there was no such thing as a pocket calculator. It is sad that I remember that. You would get a piece of lined paper and write 1 2 3 4 5 6 7 8 9 10 horizontally and then vertically and start filling in the products in a grid. Yes that was also before you had to learn the 11 and 12 times table. Well here is an easier way using a recursive CTE. First, I was looking for a way to populate a table with numbers from 1 to...
Read More
I have a table with a column named ErrorCode. When I tried to use it in a data flow in SSIS I got this error: [SSIS.Pipeline] Error: The package contains two objects with the duplicate name of "output column "ErrorCode" (2048)" and "output column "ErrorCode" (2285)". The reason for this is because SSIS automatically creates a column named ErrorCode which is used for internal error handling. By right clicking the datasource and selecting Show Advanced Editor you can rename the SSIS generated Erro...