test existance with variable name

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  August 7, 2018 at 8:08 am

  #375477

  Hello everyone

  I use this little script to test if my file exists
  public void Main()
{ string filelocation = @"c:\source\production.txt";
if (File.Exists(filelocation) == true)
{ Dts.Variables["FileExits"].Value = true; }
else { Dts.Variables["FileExits"].Value = false; }
Dts.TaskResult = (int)ScriptResults.Success; }
  now I want to change it to test the file with a name that varies
  thank you for your help

• sgmunson

  SSC Guru

  Points: 110644

  More actions

  August 7, 2018 at 12:54 pm

  #2000696

  joujousagem2006 1602 - Tuesday, August 7, 2018 8:08 AM

  Hello everyone

  I use this little script to test if my file exists
  public void Main()
{ string filelocation = @"c:\source\production.txt";
if (File.Exists(filelocation) == true)
{ Dts.Variables["FileExits"].Value = true; }
else { Dts.Variables["FileExits"].Value = false; }
Dts.TaskResult = (int)ScriptResults.Success; }
  now I want to change it to test the file with a name that varies
  thank you for your help

  Change the hard coded value to use a package variable, and properly populate that value outisde of the script task, and prior to it's execution.

  Steve (aka sgmunson)
  Rent Servers for Income (picks and shovels strategy)