Subscribe to this blog
Archives: May 2012
Basic SSIS Equivalents to T-SQL's LIKE
There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another. One of those for you might be the LIKE keyword in T-SQL. LIKE is fairly powerful in T-SQL - it does rudimentary regular expressions. How do you do that in…
3 comments, 2,547 reads
Posted in Todd McDermid's Blog on 22 May 2012
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult to have a package run properly when it can't see the source files, or can't write results to a particular network share. But it's insanely hard to get a package…
0 comments, 222 reads
Posted in Todd McDermid's Blog on 14 May 2012
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these, and how do you deal with them in SQL Server Integration Services?
Time? Version?
First, let's talk semantics. There are several unfortunately bad aspects to these names. First, the name "TIMESTAMP"…
Time? Version?
First, let's talk semantics. There are several unfortunately bad aspects to these names. First, the name "TIMESTAMP"…
2 comments, 2,945 reads
Posted in Todd McDermid's Blog on 8 May 2012