Subscribe to this blog
SQLRunner
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…
0 comments, 515 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…
0 comments, 97 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…
2 comments, 1,157 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…
9 comments, 984 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, 401 reads
Posted in SQLRunner on 8 January 2010