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

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Archives: January 2010

Handling Escape Sequences in SSIS Expression String Literals

The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic.  When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code. 

For example, a common reason you… Read more

0 comments, 391 reads

Posted in Devin Knight on 27 January 2010

Handling Escape Sequences in SSIS Expression String Literals

The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic.  When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code. 

For example, a common…

Read more

1 comments, 820 reads

Posted in Devin Knight on 27 January 2010

SSIS Checkpoints with Tasks Running in Parallel

 

Several months ago I blogged about why Checkpoints are a great feature in SSIS to use.  It seems with every feature there are potential problems you can run into and it is no different with Checkpoints.  The major problem or what some people would call a feature

Read more

0 comments, 1,118 reads

Posted in Devin Knight on 22 January 2010

SQL Lunch #8 recording

If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website.  This session was on Data Driven Subscription.  We had a great group of people with lots of good questions.  Thanks to Patrick LeBlanc, founder of SQL Lunch, for letting… Read more

0 comments, 253 reads

Posted in Devin Knight on 15 January 2010

SQL Lunch #8 recording

If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website.  This session was on Data Driven Subscription.  We had a great group of people with lots of good questions.  Thanks to Patrick LeBlanc    , founder of SQL Lunch, for…

Read more

1 comments, 215 reads

Posted in Devin Knight on 15 January 2010

Configure Report Manager to open Report Builder 2.0

Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0.  The discussion was really around will the end user actually use Report Builder and if they will should they have access to Report Builder 1.0, 2.0 or both.  I explained that Report… Read more

0 comments, 386 reads

Posted in Devin Knight on 8 January 2010

Configure Report Manager to open Report Builder 2.0

Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0.  The discussion was really around will the end user actually use Report Builder and if they will should they have access to Report Builder 1.0, 2.0 or both.  I explained that Report…

Read more

1 comments, 741 reads

Posted in Devin Knight on 8 January 2010