Hello everyone
I use this little script to test if my file exists
public void Main()
{ string filelocation = @"c:\source\production.txt";
if (File.Exists(filelocation) == true)
{ Dts.Variables["FileExits"].Value = true; }
else { Dts.Variables["FileExits"].Value = false; }
Dts.TaskResult = (int)ScriptResults.Success; }
now I want to change it to test the file with a name that varies
thank you for your help
Change the hard coded value to use a package variable, and properly populate that value outisde of the script task, and prior to it's execution.