|
|
Browse by Tags
All Tags » SQL » 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 ...
-
In the past I have talked alot about how you can use the script component in a number of different ways. It provides a quick and easy way to add custom, performant functionality to your data-flows. Of late I haven't provided many examples of using the script component but then I read this post on the SSIS forum that asked how to ...
-
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 ...
|
|
|