Check if File Exists

// Add the following line on #region Namespaces using System.IO; // public void Main() should be replaced by: // make sure the variable names matches the ones you created on SSIS public void Main() { // TODO: Add your code here String FullPath = Dts.Variables["User::strFilePath"].Value.ToString() + Dts.Variables["User::strFileName"].Value.ToString(); if (File.Exists(FullPath)) { Dts.Variables["User::flagFileExists"].Value = 1; } //MessageBox.Show(FullPath); //MessageBox.Show(Dts.Variables["User::flagFileExists"].Value.ToString()); Dts.TaskResult = (int)ScriptResults.Success; }

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.