THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » sql server inte... » C#   (RSS)
  • Verify a connection before using it [SSIS]

    Just recently I've inherited some SSIS packages that were in dire need of fixing however, as is often the case, most of my battles were with connection string configurations. It always baffles me when I see packages that don't log information that would be useful for debugging purposes and when its me that has to debug those packages I tend to ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 25, 2011
  • Lock variables in Script Task using C# [SSIS]

    If you have ever written code to lock variables inside a SSIS Script Task or Script Component then you will probably have written some VB.Net code that looks something like this: Public Sub Main() Dim vars As Variables Dim fireAgain As Boolean = True Dts.VariableDispenser.LockOneForRead(''VarName'', vars) 'Do ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 29, 2010
Privacy Statement