SSIS Task that check if or Loop through until File exists

• ruancra

  SSC-Addicted

  Points: 494

  More actions

  February 25, 2011 at 1:35 am

  #235001

  Hi all

  Using SQL 2008 R2, Visual Studio 2008

  I have created a SSIS Package that checks a location for a file, and loops until it exists and then mails the file to a recipient.

  When creating the script task i have an option of using ScriptLanguage: Microsoft Visual Basic 2008 or Microsoft Visual C# 2008, i used Microsoft Visual Basic 2008

  Here is the package: http://dichotic.wordpress.com/2009/10/20/ssis-waiting-for-a-file/

  However, when inserting the script into the script editor, all the lines that reads "Dts.Variables" are underlined with error: Name 'DTS' is not declared.

  I have no experience in scripting, can someone please help?

  Much appreciated

  Ruan

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 25, 2011 at 1:52 am

  #1291403

  Sounds like a better bet might be the WMI watcher

  http://msdn.microsoft.com/en-us/library/ms141130.aspx

  ---

  
  Clear Sky SQL
  My Blog[/url]

• ruancra

  SSC-Addicted

  Points: 494

  More actions

  February 25, 2011 at 2:47 am

  #1291420

  Thanks Dave! It works, much quicker than using all the scripting tasks.

  Thank you.