Update: I disabled all of the tasks except the ones that had failed when I ran the package from the job, then tried to run the package from my desktop. ...

Computer science degree from a liberal arts school here. Our major started with programming, the "weed-out" course (Assembly Language) was a 200-level one, as were the hard theory required...

The first volume of Naomi Novik's Temeraire series is apparently somewhere in the process of becoming a movie and I can't wait to see what happens with it.

I'd love to...

No experience with this in the corporate world (the visitor spaces have never had any time limit, although we have had emails from management that there were employees in visitor...

I went to a women's college in the mid-'90s. In my dorm of ~60 women, we had 8 Jennifers, and that seemed to be the ratio across campus. ...

Agreed completely with finding some kind of stress relief outside of the coding world. My martial arts training leans more towards the mental than the physical though. I've...

I certainly fell into database development work. I avoided the one database course they offered at school because I couldn't stand the professor. My first job was in...

This is true for not just DBAs, but everyone who does anything that is not plain "a trained monkey could do it" work. Make yourself irreplaceable in other ways,...

Jeff, I hope it helps.

MyDoggieJessie, unfortunately it comes back with the same error whether I specify the columns in the inner select statement or not.

I had to change the numeric columns on the SQL Server side to allow NULLs, but it ran just fine once I'd done that.

With regards to the SQL Server, we backed up the database on ServerA and restored it as-is on to ServerB. I've been the only one working on the SQL...

As data professionals, I would think that every last one of us would refuse to give away our login information to ANY social networking site. We are entrusted with...

Thanks very much! I'll give it a look. I've never done anything using certificates (no surprise since the document you've linked to notes that they weren't available prior...

Thanks all! Got the coding finished yesterday, waiting on one more bit of info from the business before I can test it. Here's hoping...

Thanks, Craig! I'll take a look and hopefully I'll be able to get things working.