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

SQLRunner

This blog is syndicated from SSIS - SQL Server Tidbits(http://www.josefrichberg.com/)

Archives: February 2012

SSIS Script Component Source -- Proc/Select Stmt

I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations.  I had to build one moments ago and realized I am tired of looking back through my presentations to build them.  Here is a sample script that you can… Read more

0 comments, 831 reads

Posted in SQLRunner on 21 February 2012

PASS Virtual Chapter: SSIS Enhanced Threading Framework

I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design.  Here is the abstract:

"How is it possible to aggregate 12,000,000 records of sales data in a short time window?  In this presentation you will learn the techniques used to make this…

Read more

0 comments, 51 reads

Posted in SQLRunner on 21 February 2012

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:

 

  1. Quickly identify what tables have the highest IO in a particular query
  2. Learn a new language (Ruby)

 

The problem was simple.  I needed to easily identify the problem areas of a complex stored procedure.… Read more

0 comments, 264 reads

Posted in SQLRunner on 16 February 2012

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column.  The conversion was taking an ISBN13 which is usually defined as char(13) and converting it into a bigint.  All valid ISBN13s are valid bigint.… Read more

0 comments, 369 reads

Posted in SQLRunner on 1 February 2012