Full disclosure: There might be a better way to do this. I am not aware of it.
- Maintaining multiple DB environments (Local, Shared Dev, Staging, Prod) means needing to maintain multiple SSIS environments.
- SSIS packages are tricky to configure using the existing toolset – it’s easy to accidentally use…
One of the databases that I support reports all money values in both the local currency and US Dollars. Very often we will do all of our calculations in a table variable using the local currency and then calculate USD equivalents at the very end.
With this methodology, adding a… Read more
Tobias Ternstrom from Microsoft gave a great talk at Tech Ed regarding upcoming features of SQL Server Denali. His presentation was engaging, funny, and informative!
You can check it out on the Channel 9 site here (72 minutes):
I have to say that I am very excited about all… Read more
(Yet another boring org chart example – except this one has multiple roots)
If you want to test if you’re currently debugging an SSIS package via BIDS/Visual Studio, or running normally via DTExec, you can use the following utility functions inside a Script task.
Public Function SSIS_IsBIDS() As Boolean
Return (SSIS_Environment() = "DtsDebugHost")
Public Function SSIS_IsDTExec()… Read more
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row to the next row and I was trying to do my best to avoid using cursor for this. I was using the old trick of having an IDENTITY() field and… Read more
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
DECLARE @Report TABLE (
ReportID INT PRIMARY KEY,
ReportName VARCHAR Read more