If the file does not exist continuously

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  July 30, 2018 at 9:02 am

  #354789

  Hello everyone
  I have a system task that attempts to copy files from one directory to another directory
  the pb is that my script is out in error if it does not find one of my file
  while I want my script to continue processing file copying even if there are non-existent files
  Who can help me on this need please
  
  
  
            Dts.TaskResult = (int)ScriptResults.Success;
    String Filepath = Dts.Variables["User::name"].Value.ToString();
    if (
    File.Exists(Filepath))
    {
      Dts.Variables["User::File_exist"].Value = 1;
      Dts.TaskResult = (int)ScriptResults.Success;
  
  
  

• Phil Parkin

  SSC Guru

  Points: 247109

  More actions

  July 30, 2018 at 9:11 am

  #1999495

  My French is not good enough to enable me to understand exactly what the problem is here.
  Assuming you have a list of files held somewhere, a simple script task should do the job. IN pseudo code:

  foreach (file in list)
  {
  if (File.Exists(sourceFilePath))
     {File.Copy(sourceFilePath,targetFilePath);}
  }

  ---

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  July 31, 2018 at 2:28 am

  #1999640

  Sorry I did not manage to do it