|
|
Browse by Tags
All Tags » SQL Server 2005 » SSIS » Nugget
-
About a month ago I wrote this very simple blog post explaining how one might go about stripping off the last word from a sentance in the pipeline. My Conchango colleague James Saull thought that this would be ripe for a regular expression (and he's right) and asked if we could we apply regular expressions in SSIS.
The answer is ...
-
We all know what system tables are right? They are the tables within the master database that hold the metadata of all the objects stored in our SQL Server. In SQL2005 an extra set of views called the sys views has been provided on top of the system tables that makes even more information available to us.
How about INFORMATION_SCHEMA views? ...
-
Did you know....
...that you can run regular SQL Server transactions in SSIS over multiple tasks without requiring the use of Distributed Transaction Coordinator (DTC)? Well I didn't but thanks to that man again, Kirk Haselden, I do now.
The default behaviour of a Connection Manager is that every task has its own connection which is why they ...
|
|
|