Please delete, posted in wrong area.

I am getting two different messages from this procedure. If I run the job I get this error, " Incorrect syntax near '%'. [SQLSTATE 42000] (Error 102)."

If I run the...

Ahhhhhhhhhhhhhh. Sorry, not a VBScript guy and had a bit of a brain freeze this afternoon while stepping through your process.

Thanks!!

I am confused about the part "SQLCMD that uses the raiserror command to send messages to the Windows Event Application Log". Is this a job step executed as Operating...

What do you mean by "Make sure pkzip is in the path and found by the shell prior to using this script"? Do you mean to set up a...

Drew,

Never mind on this. I just ran a select statement using a convert statement for the datetime and for whatever reason, still got the error. I rewrote this...

Drew - Great script!

However, similar to Gary I am also getting the conversion error:

Msg 241, Level 16, State 1, Line 2

Conversion failed when converting datetime from character string.

When I bracket...