Browse by Tags

• Script Task
• sql server integration services
• ssis

• 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 Read More... Posted Tuesday, October 25, 2011 4:35 PM by jamiet | 5 Comments Filed under: C#, sql server integration services, ssis

• 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 Read More... Posted Thursday, July 29, 2010 2:09 PM by jamiet | 2 Comments Filed under: C#, Script Task, sql server integration services, ssis