recover file extension

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  August 2, 2018 at 9:03 am

  #374114

  Hello everyone
  Who can help me please on this point 
  I am looking to recover the extention of my files
  for that I used a script task
     public void Main()
        {
            // TODO: Add your code here
    

      Dts.Variables["User::Extention"].Value = right(Dts.Variables["User::Extention"].Value, 3);
;

              Dts.TaskResult = (int)ScriptResults.Success;
        }

  Who can help me on this point please