Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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…

Read more

3 comments, 4,186 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…

Read more

0 comments, 509 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"…

Read more

2 comments, 4,731 reads

Posted in Todd McDermid's Blog on 8 May 2012