PL/C (supposedly the Classroom version of PL/I), Fortran, PDP-11 BASIC-PLUS, PDP-11 Assembler, APL, Pascal, LISP, FORTRAN, then a stint with SAS (college and grad school are great places to play...

Hi Tim,

The failures are a bit out of my control. Its a third party Upsert Data Flow task. I suspect that every now and then, it hiccups and forgets to...

to answer the question, there is a changelog table associated with each table that has the changedate and a calculated modification number, so the initial extract is all records in...

Thanks! Its an idea, plus there already is some room to do something similar to what you described in order to avoid re-running a successful refresh in the event of...

we tie our database connections to specific SQL Server userid's for various security and auditing reasons.

By windows security, I mean active directory. We use sqlserver logons so that the userid remains consistent whether in development, staging, or production. That doesn't happen using the Windows/active directory...

same security.

I am thinking its my connection string, that I am trying to store it in the package configuration, but exactly what is off, is the thing I can't...

a double check with the DBA's confirms we are supporting mixed mode authentication.