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 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, 195 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, 299 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, 2,464 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…

Read more

0 comments, 118 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…

Read more

2 comments, 124 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, 163 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, 915 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…

Read more

3 comments, 1,660 reads

Posted in SQLRunner on 1 February 2010