snippet3update.cs

// This try/catch block will capture catastrophic failures (such as specifying the wrong path to winscp).
try
{
    winscp.Start();

    winscp.StandardInput.WriteLine(sessionOptionString);
    winscp.StandardInput.WriteLine(connectString);
    winscp.StandardInput.WriteLine(getString);
    winscp.StandardInput.Close();

    // Set the outStr to the output value, obfuscating the password
    outStr = winscp.StandardOutput.ReadToEnd().Replace(":" + Dts.Variables["$Package::pServerUserPassword"].GetSensitiveValue().ToString() + "@", ":*******@");

    // Wait for the application to exit
    winscp.WaitForExit();

    returnVal = winscp.ExitCode;
}
catch (Exception ex)
{
    errStr = "An error occurred when attempting to execute winscp.com: " + ex.Message.Replace("'", "\"").Replace("--", " - ");
}