// 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.