SSIS Script Task Editor

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  April 28, 2015 at 3:27 pm

  #398389

  Hi,

  I have a SSIS package which is using "Script Task Editor" control Flow.

  I am trying to understand what this is doing.

  It has two variables:

  bol_FileExists --- data type boolean and value False

  str_ArchiveFileName --- String --- \\servername\d$\Test\Journal Target.csv

  It is using Microsoft Visual C#2008 as Scripting Language:

  Here's the script it is using:

  public void Main()

  {

  Dts.Variables["str_ArchiveFileName"].Value = @"\\servername\d$\ftp\Test\Archive\Journal - " + Convert.ToString(DateTime.Today).Replace("/", "-").Replace(":", "").Replace(".", "").Replace(" 120000 AM", "") + ".csv";

  Dts.TaskResult = (int)ScriptResults.Success;

  }

  }

  }

  }

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  April 29, 2015 at 1:37 am

  #1794205

  This script task sets the value of the variable str_ArchiveFileName to something like \\servername\d$\ftp\Test\Archive\Journal - 2015-04-29.csv

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP