Thursday, April 4, 2013

Creating an Empty file using SSIS Script Task


Add variable "FilePath" to the read variable in script editor
 
public void Main()

{

// TODO: Add your code here



string filepath = Dts.Variables["FilePath"].Value.ToString();

           



System.IO.
File.Create(filepath);
           

Dts.TaskResult = (int)ScriptResults.Success;

}