Heads-up! In MySQL, WEEKDAY(‘2012-11-09′) = 4 (0-6 starting on Monday), but in SQL Server, DATEPART(dw,’11/09/2012′) = 6 (1-7 starting on Sunday). If you’re extracting data from MySQL to load into SQL Server, the correct translation is ((WEEKDAY(date)+1)%7)+1.
I’m migrating a Business Intelligence project from SQL Server 2005 to SQL Server 2012. Microsoft has, overall, done a great job with their development and migration tools, and some of the new features of SQL 2012 are great and will save me a lot of time going forward. One neat new feature in SQL Server… Continue reading Converting to Project Connection Across Multiple Packages in SSIS 2012