Subscribe to this blog
SQLRunner
Archives: February 2010
Managing user data and response through 'drop boxes'
There are a few ways to get data from a client to your system; FTP or email. Internally we tend to use email for two reasons: everyone has it and it provides an audit trail (I know who sent what and when). The corporate email standard is MS Outlook, which… Read more
0 comments, 104 reads
Posted in SQLRunner on 24 February 2010
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I showed you how to access variables from within an Script Destination Component. You can not access the read/write variables using the standard Dts.VariableDispenser that you are familiar with… Read more
0 comments, 143 reads
Posted in SQLRunner on 17 February 2010
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I showed you how to access variables from within an Script Destination Component. You can not access the read/write variables using the standard Dts.VariableDispenser that you are familiar with… Read more
3 comments, 1,519 reads
Posted in SQLRunner on 16 February 2010
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I will say the experience was not what I imagined. I guess everyone has different ideas of what it is like to have an editors review your…
0 comments, 61 reads
Posted in SQLRunner on 9 February 2010
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I will say the experience was not what I imagined. I guess everyone has different ideas of what it is like to have an editors review your…
2 comments, 62 reads
Posted in SQLRunner on 8 February 2010
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I built for SSIS. When you build the threading framework you have a set number of threads running and I have been looking for a way to modify the number of… Read more
0 comments, 79 reads
Posted in SQLRunner on 7 February 2010
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I built for SSIS. When you build the threading framework you have a set number of threads running and I have been looking for a way to modify the number of… Read more
6 comments, 580 reads
Posted in SQLRunner on 7 February 2010
Sending SSIS Errors to the Windows Event Log
In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS Log (link). A good friend of mine and system engineer extraordinaire Eugene L. (last name withheld to protect the guilty :) ) suggested that…
3 comments, 954 reads
Posted in SQLRunner on 1 February 2010