Yes I did. In the Agent log the message is still the same :
[136] Job CSM LoadComputerSum mary reported: The process could not be created for step 1 of job 0xCD093A12EDD4C A4E88C27869FAC5 E6DF (reason: The system cannot find the file specified).
I have also tried quotes and anything else that came to mind. Only way to get it to run is to right click on the DTS Local Package and choose 'execute package'. Or paste the code in...
User Profile
Collapse
-
SQL server and MSDE
I have a similar stored procedure on 3 separate SQL servers, a job calls it and the local package defines it. I have the same process I need to run on an a SQL Desktop engine. No matter what I do the job fails. I suspect that the server name XXXserver\THISS ERVER containing the backslash causes the DTSRun /S command in the job to fail. Does anyone have a work around for this? I cannot believe the hours I have spent searching for this solutio...
No activity results to display
Show More
Leave a comment: