I want to pass variable name User::FileDestinationPath instead hardcode folder \\[servername]\EventLog\ in SSIS script task. Please advise.

• saptek9

  Ten Centuries

  Points: 1155

  More actions

  May 21, 2018 at 9:01 am

  #349561

  I want to pass variable name  User::FileDestinationPath instead hardcode folder \\[servername]\EventLog\ in SSIS script task. Please advise.
  using System.IO;

  string[] filePaths = Directory.GetFiles(@"\\[servername]\EventLog\","*.csv",System.IO.SearchOption.AllDirectories);
  foreach (string filePath in filePaths)
  File.Delete(filePath);

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  May 21, 2018 at 9:09 am

  #1991254

  saptek9 - Monday, May 21, 2018 9:01 AM

  I want to pass variable name  User::FileDestinationPath instead hardcode folder \\[servername]\EventLog\ in SSIS script task. Please advise.
  using System.IO;

  string[] filePaths = Directory.GetFiles(@"\\[servername]\EventLog\","*.csv",System.IO.SearchOption.AllDirectories);
  foreach (string filePath in filePaths)
  File.Delete(filePath);

  Add the variable to the 'ReadOnlyVariables' collection of your script task and reference it in code using Dts.Variables["User::myStringVariable"].Value

  ---

• saptek9

  Ten Centuries

  Points: 1155

  More actions

  May 21, 2018 at 9:58 am

  #1991281

  i tried as follows: but still not working.
  public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
      {
  private string NETWORK_PATH;
    
     public void Main()
          {
      NETWORK_PATH = (string)(Dts.Variables["User::FileDestinationPath"].Value);
      string[] filePaths = Directory.GetFiles(@"NETWORK_PATH", "*.csv", System.IO.SearchOption.AllDirectories);
      foreach (string filePath in filePaths)
        File.Delete(filePath);

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

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  May 21, 2018 at 10:16 am

  #1991287

  Your C# skills could do with some work! 

  Try this:

  public void Main()
{
string networkPath = Dts.Variables["User::FileDestinationPath"].Value;
string[] filePaths = Directory.GetFiles(networkPath , "*.csv", System.IO.SearchOption.AllDirectories);
foreach (string filePath in filePaths)
File.Delete(filePath);

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

  ---