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: January 2010

Try Catch within an SSIS Script Tasks and Components

 Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice.  The thing you want to be able to do is push any errors you trap to a log file.  The syntax is somewhat simple, but it took me some…

Read more

0 comments, 693 reads

Posted in SQLRunner on 30 January 2010

Working with ADO.Net variables in SSIS scripts

I am always looking to improve the performance of my SSIS packages.  I try to do as much work within the package as possible, only going to external stores (databases, flat/raw files) as little as possible.  There are a number of reasons for this.  Raw files are incredibly fast and…

Read more

0 comments, 188 reads

Posted in SQLRunner on 25 January 2010

Working with ADO.Net variables in SSIS scripts

I am always looking to improve the performance of my SSIS packages.  I try to do as much work within the package as possible, only going to external stores (databases, flat/raw files) as little as possible.  There are a number of reasons for this.  Raw files are incredibly fast and…

Read more

2 comments, 1,761 reads

Posted in SQLRunner on 25 January 2010

Implement a stack in SQL Server using stored procedures

In this article I will show you how to implement a stack.  In programming, stacks are a great way to manage data or work.  Everyone pulls from the same pool and there is no duplication (once a unit is pulled off the stack, it is no longer available to any…

Read more

9 comments, 1,523 reads

Posted in SQLRunner on 10 January 2010

Virtual Presentation on SSIS Workload Thread Load Balancing

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 I have developed  to randomize the input data and then use the SSIS threading framework to distribute the workload. These techniques make it possible to process… Read more

2 comments, 609 reads

Posted in SQLRunner on 8 January 2010