I prefer Convert() over Cast() because I can do string tricks with my GETDATE() and still take it back to a valid datetime value. I'm not sure if you can...

I just noticed another problem. At no time in this scenario, Maina-456685, are you actually checking dbo.Contract for duplicates. You only ever check your staging table, dbo.TempCustomer for duplicates.

So what...

Ah. I did not catch that fact. Chris, you are correct. So even if the ContractAuditID problem is corrected, the code will still fail.

A few minor nitpicks that might not matter in your current environment but could cause problems for you later. (FYI: Grain of salt moment. These just happen to be two...

Maina-456685 (10/27/2010)

---

Condition 1: If an entry is duplicated in TempCustomer, insert into ContactAudit table.

....

Condition 3: If an entry is not duplicated in TempCustomer, but already exists in Contact,...

Dread,

Glad your problem is resolved and thank you for posting your solution.

If you ever do remember the forum name or the forum thread, please make sure to link it...

Yeah, my edit must have crossed your posting.

Michael,

EDIT again: I take back everything I just said. I forgot to re-login. Crap. What was MS thinking when they did this?

I just tested impersonate. You're working off an invalid...

I'll double-check the impersonate, but when I logged in as the SecurityAdmin account, I was unable to grant actual SysAdmin to my own account.

Edit: Changing my answer.

It's a semi-good point. A user with every other permission cannot grant herself sysadmin access even when she has SecurityAdmin perms. Which is good from a security...

Have you used the multi-server admin tools yet? That's my primary interest in R2.

Well, I'm glad you found what could be the error.

I'm a little confused as to why you need to take liberties with the code for SSIS. Usually, you just need...

Rocky Horror Picture Show

Showing at a theatre near you... Though I do believe Comcast advertised it for a local channel last weekend...

Thank you for the information on costs. I hadn't seen that either.

jez.lisle (10/26/2010)

---

EDIT: You may also have to put the -S + @@ServerName before the -T. You need the server to log into before the credentials, I believe. But test it...