Ditto

SSMS

What is in the contract with the vendor? Are you the customer? If your company is paying alot of $$ and then paying you to code work arounds they are...

That did the trick.

Thanks,

Sqlraider

I finally got this working and thought I'd post the solution.

In the SQL Agent job Step I changed the type to:

Type: Operating sytem (CmdExec)

And the Powershell script looks like...

Joie,

The type is:

Type: PowerShell

in the SQL Agent job and the command is powershell.exe

Gaz,

I removed all references to the Stop and error catching within the powershell script but the SQL job...

Iwas Bornready (2/2/2015)

---

Sometimes (always?) it just comes down to time and money. I can give it to you quick and dirty today or elegant tomorrow. If I go elegant then...

Print

Temp tables

Output with the Merge statement along with rollback

Depends on the situation.

Thanks and Happy New Year to all those on SQL ServerCentral that have shared their knowledge!!

Being challenged and having the ability to implement better automated processes (in place of this is how we've always done it) makes for a fun job.

I don't eat lunch...so I can leave an hour early!

AN end to the never ending Project(s)!

paul.kemner (12/18/2014)

---

I know someone in the US who committed a minor "stealing a snickers bar" offense that ended up in the police blotters of a couple local newspapers. When you...

I've said that this will be my last job for the last 3 jobs that I've had. 🙂

I'm 6 years away from an 'early' retirement because I've rolled over every...

It's too late in the year to start anything NOW!!

🙂