Users are out in another country and have not been trained for SSIS. DTS Import/Export Wizard works for imports but only exports up to 5k to text files.

I am trying this with errors. I'm not sure where to put the case/exec statement.

select distinct j.Name as 'SNTest', h.run_date as LastStatusDate,

case h.run_status

when 0 then 'Failed'

when...

This is the error I get when running this

Server: Msg 170, Level 15, State 1, Line 13

Line 13: Incorrect syntax near 'max'.

Server: Msg 195, Level 15, State 1, Line 32

'OBJECT_SCHEMA_NAME'...

I tried this and it starts the execute statement and marks as successful as soon as it is run, all jobs were run about same time. It does not wait...

I get this error..

Line 5: Incorrect syntax near ')'.

If you create the same drives on the new server or attach same drives to new server, when you detach and attach it should all sync up. I would rather...

Awesome Thanks!

Is this for sql server 2k or 2k5? Are you running as a user or sa? It may be just the permissions. No fix for my issue yet.

I have the same issue, however, to get it working in the meantime...

You can run it as a t-sql script with the following

exec master.dbo.xp_cmdshell 'dtsrun /S ServerName /E /NJobName'

I will try that out. thanks!

You can run it as a t-sql script with the following

exec master.dbo.xp_cmdshell 'dtsrun /S ServerName /E /NJobName'

Yes, I tried as both sa and windows authenticated. I get the same error as both.

I've tried dtrun with the quotes as well. also removed the ~. ive done this several times at other companies, for some reason, it is not working here. could it...

using the dtsrun by itself does not work, but executing it does. what is going on??? is it a setting?

Thank you so much! I just found another similar post here.

http://www.sqlservercentral.com/Forums/Topic494729-5-1.aspx

thanks again!