Creating Configurable and Portable SSIS Packages Part 3 In this article I’ll conclude my set of articles into SSIS configuration. This article will be
Creating Configurable and Portable SSIS Packages Part 2 In Part 1 I showed how a simple SSIS package could be created using variables and expressions as a b
Get a comma-delimited list of columns One of the things I've been doing recently has been writing lots of SQL inserts in which I've had to
How to tell what has changed in a SQL Server Database One of the things I've had to do recently is work out if objects on a SQL Server had been modified a
How to Import and Export DTS packages quickly This article applies to DTS packages on SQL Server 2008 R2, but will probably work on most other ver
Handling Orphaned Database Users This isn't the first time I've had to deal with orphaned users in SQL Server, and probably won't be