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 » 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
  • SSIS Script Task In SQL Server 2008 Can Use VB Or C#

    Where do I send a thank you letter? Finally we are allowed to use C# in the SQL Server Integration Services Script Task. I always wondered why SQL Server 2005 only uses VB and not C#, you can use C# in the SQLCLR but not in a Script Task. It turns out that SSIS in SQL Server 2005 uses VSA (Visual Studio for Applications) but SQL Server 2008 will ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 4, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement