Monday, May 27, 2013

logging methods for script component

Log("Some log text {0}, {1}, {2}", 1, 2, 3);
   or
Log("Error-{0}; Description-{1}\n", Get("System::ErrorCode"), Get("System::ErrorDescription"));

 ...

private void Log() { Log(new string('*', 20)); }
private void Log(string str, params object[] pars)
{
    bool fireAgain = false;
    Dts.Events.FireInformation(1, "custom", string.Format(str, pars), "", 0, ref fireAgain);
       or
    string logFile = "d:\\SSIS.log";
    File.AppendAllText(logFile, string.Format(str, pars));
}

No comments:

Post a Comment