The Weird and The Wonderful

CASE WHEN TX.TX_TYPE = 'R' AND TX.TX_MOSTYPE = 'P' AND TX.TX_DEST_STATUS = 'A' THEN 'PO Receipt'
	 WHEN TX.TX_TYPE = 'R' AND TX.TX_MOSTYPE = 'P' AND TX.TX_DEST_STATUS = 'U' THEN 'PO Receipt Hold'
	 WHEN TX.TX_TYPE = 'R' AND TX.TX_MOSTYPE = 'P' THEN 'Other'
	 WHEN TX.TX_TYPE = 'R' AND TX.TX_DEST_STATUS = 'A' THEN 'WIP Receipt'
	 WHEN TX.TX_TYPE = 'R' AND TX.TX_DEST_STATUS = 'U' THEN 'WIP Hold'
	 WHEN TX.TX_TYPE = 'R' THEN 'Other'
	 WHEN TX.TX_TYPE = 'I' AND ISNULL(RTRIM(TX.TX_MOSJOB),'')  = '' THEN 'Shipment Return'
	 WHEN TX.TX_TYPE = 'I' THEN 'Reverse Issue'
	 WHEN TX.TX_ORIGIN_STATUS = TX.TX_DEST_STATUS THEN 'Loc Transfer'
	 WHEN TX.TX_ORIGIN = 'SCRAPPED' THEN 'Reverse Scrap'
	 WHEN TX.TX_ORIGIN_STATUS = 'J' THEN 'Count Adj Up'
	 WHEN TX.TX_ORIGIN_STATUS = 'D' THEN 'PN Change To'
	 WHEN TX.TX_ORIGIN_STATUS = 'I' THEN 'Reverse Unplanned Issue'
	 WHEN TX.TX_ORIGIN_STATUS = 'A' AND TX.TX_DEST_STATUS = 'U' THEN 'Hold'
	 WHEN TX.TX_ORIGIN_STATUS = 'U' AND TX.TX_DEST_STATUS = 'A' THEN 'Off Hold' ELSE 'Other' 
END AS Transaction_Type	

As you wrote:

Everything makes sense in someone's mind

.RedirectStandardOutput = False

Console class members that work normally when the underlying stream is directed to a console might throw an exception if the stream is redirected, for example, to a file. Consequently, program your application to catch System.IO..::.IOException if you redirect a standard stream.

string dateStr = DateTime.Now.Day.ToString("00") + DateTime.Now.Month.ToString("00") + DateTime.Now.Year.ToString();
string timeStr = DateTime.Now.TimeOfDay.Hours.ToString("00") + DateTime.Now.TimeOfDay.Minutes.ToString("00") + DateTime.Now.TimeOfDay.Seconds.ToString("00");

string path = FileOutputDir + GetProviderName() + "-Summary-" + dateStr + "-" + timeStr + ".csv";
string path = string.Format("{0}{1}-Summary-{2}", FileOutputDir, GetProviderName(), DateTime.Now.ToString("ddMMyyyy-HHmmss") + ".csv");

//returns a string representation of the date used to create
//the logs file. The logs file are somethnig like '15_09_2009.log'.
//a new log file is created each day if and ONLY if an error
//apears while using the program that day.
public static string GetStringDate(DateTime dt)
{
    StringBuilder sb = new StringBuilder();

    //Month
    int mnth = dt.Month;
    if (mnth < 10)
    {
        //leading zero
        sb.Append('0');
        sb.Append(mnth);
        sb.Append('_');
    }
    else
    {
        sb.Append(mnth);
        sb.Append('_');
    }
    //day
    int day = dt.Day;
    if (day < 10)
    {
        //leading zero
        sb.Append('0');
        sb.Append(day);
        sb.Append('_');
    }
    else
    {
        sb.Append(day);
        sb.Append('_');
    }
    //year
    sb.Append(dt.Year);

    //return the formated string
    return sb.ToString();
}