Monthly Archives: January 2013

SQL 2012 – Generate Calendar with Cross joins

“cross join” is a difficult to explain to trainees.  The mechanics aren’t very complicated.  However, the question is where you would ever use them? One example that I came up with is generating a calendar.  Let’s say I want to … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

SSIS Template, changing GUIDs

There has been a basic method from SSIS 2005 for creating an SSIS package template.  You create package, then put that package into a magical folder (under the Common7 folder of the appropriate version of Visual Studio), and voila you … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment