THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » C#   (RSS)
  • Running SSIS packages from C#

    Most of the developers and DBAs know about two ways of deploying packages: You can deploy them to database server and run them using SQL Server Agent job or you can deploy the packages to file system and run them using dtexec.exe utility. Both approaches have their pros and cons. However I would like to show you that there is a third way (sort of) ...
    Posted to Piotr Rodak (Weblog) by on April 9, 2012
  • 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
  • Folder Info

    Although not a SQL Server post, I thought this would be helpful for anyone... In an attempt to clean up my laptop, I have been archiving old projects, setup files, etc., off to a file server. Alas, some directories have a multitude of subdirectories, and trying to figure out how much space each takes up is cumbersome at best. So, I decided to ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on January 30, 2007
Privacy Statement