RESOLVED

For future reference, we found that adding the SSIS proxy account to the DB2ADMNS local users group solved this problem.

jwmott (12/22/2016)

---

Do I have this wrong? if a baseDate of 1/1/2006 at 07:00 represents the beginning of Shift A, then the shift date of 12/31/2005 at 06:00 represents shift...

Demonstrates good knowledge of ASCII 😉

CHAR(...) + 65 is far too dependent upon the shift labels A, B, C. If they changed to non-contiguous strings, then this is out the window.

Replace your last SELECT statement with this little "trick" I learned about 40 years ago (literally) -- loose the CASE entirely --

SELECT SUBSTRING('ABC', ABS(DATEDIFF(DD, @compareDate, @baseDate)) % 3 + 1,...

Good point re UPPER()

Also, why stop at one CHECKSUM() when you could use two -- one for the local part and one for the domain -- and a bigint. This...

Jeff,

Whoa, using SQL to do cross-tabs really is "old school" (circa mid-90's or before.) It just wasn't designed for this.

Do yourself a BIG favor and try Analysis Services. The...