Home Forums SQL Server 2012 SQL 2012 - General SSIS Script Task to Check if File Exists (to set Precedence Constraint) RE: SSIS Script Task to Check if File Exists (to set Precedence Constraint)

  • LOL I'm an idiot.  Square brackets!

           public void Main()
            {
        MessageBox.Show(Dts.Variables["User::src_inbox_folder"].Value.ToString());
        Dts.Variables["User::is_new_file"].Value = System.IO.File.Exists(Dts.Variables["User::src_inbox_folder"].Value.ToString());

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

    [font="Courier New"]ZenDada[/font]