sp_help_job might be a better option for you.

I looked into this once before when writing a synchronous version of sp_start_job and I think the trouble you're going to face, whether...

Did you create the text file with a list of your instances?

This is what you should see:

Name: Job Name 1

CurrentRunStatus: Idle

CurrentRunStep: 0 (unknown)

LastRunDate: 03/30/2013 18:53:11

Name: Job Name n

CurrentRunStatus: Idle

CurrentRunStep: 0...

Are you sure you're comparing to the correct instance?

When I run this PoSh code:

Add-PSSnapin SqlServerProviderSnapin100

Add-PSSnapin SqlServerCmdletSnapin100

Set-Location SQLSERVER:\SQL\orlando\sql2008r2$i = ls

$i | %{$_.Databases}

This is what is run on the instance when...

There was another thread with a similar problem that turned out to be a missing .NET Framework 4.0 install and the error message was less than helpful.

Heh, no need to drink. At first, SSIS will make your head spin anyway 😀

You're very welcome! I would be happy to assist with any SSIS questions you might have down the line too 😉

SET @sql = 'EXEC master.sys.xp_cmdshell ' +

'''COPY \\server\SurveyComputing\Sample\SentToSPSS\' + @data_file +

'+\\server\SurveyComputing\Sample\SentToSPSS\' + @file_name +

' \\server\SurveyComputing\Sample\SentToSPSS\' +...

Even if MERGE supported such changes, chances are the source resultset from the MERGE would need to be completely copied to the remote server in order to facilitate. Consider creating...

This KB article covers a lot of the most common reasons for the problem you are describing. I pass it along quite often:

SSIS package does not run when called from...

Sounds like you are OK with the File Watcher Task, it's a good tool, but I figured I would throw in another option that will help accomplish the same but...

By default TYPE is not going to preserve Unicode data for you and I do not know of a way to setup the environment or call it where it will....

I was hoping to see some Dynamic SQL or external calls to Linked Servers or something else that might help explain the difference, but no luck.

Hmm, I tested my query on a 2005 instance and it worked fine:

PS And to confirm, the file looks good:

Hmmm, -w works for me. Please check the command line you are issuing to xp_cmdshell.

You can try this simple command line as a proof-of-concept.

bcp "select top 10 object_id, name...

It saddens me a bit that the code is accessing the command prompt and the file system from within T-SQL, especially as part of an applicaiton design, but from your...