Nice, I new the answer and managed to click on the correct answer as well.

Today is already shaping up to be better than yesterday. 🙂

Argh, good question Hugo.

Sadly, I checked off the ones that weren't valid, and forgot to switch them before hitting submit. :angry:

Nice question.

Ok, I think I might know what is going on.

You've created the job running this package as a sysadmin, so the package is being executed as the SQL Agent service...

Ok, I'm a bit confused now.

Are you running this package on the server using the SQL Server Job Agent?

Hmm, there must be some additional reason it is looking for interactive input then. Your best bet would be to log into the server interactively as the account you...

You are trying to run pscp.exe from a location that is not trusted by the server for running executables.

To fix this, you will need to either add the...

You'll need to add the file server shares that those executables in your batch file are on as trusted sources on your server.

You'll want to check with an...

I'm curious why you are not using an "Execute Task" task to run the batch file?

If the executable is waiting for an interactive response, it will appear to hang. ...

Ugh, I overlooked the 0 value as well.

Maybe I should wait to answer these questions in the afternoon. :doze:

Good question though.

We named our instances with a sequence number to keep the Development, Staging, and Production servers associated, something like this:

DEV01, DEV02, DEV03,

STG01, STG02, STG03,

PROD01, PROD02, PROD03

So DEV01, STG01, PROD01 would...

Nice question, and a nice example showing that data type issues don't always result in an error. Implicit conversion isn't always your friend.

Thank you for a nice and straight forward question for a Monday morning.

🙂

Ouch, this one made my brain hurt.

Impossible to answer, but it did make me think.

Neat trick mtassin, I've never seen an insert statement using DEFAULT and no columns listed before.