User Profile

Collapse

Profile Sidebar

Collapse
tpecka
tpecka
Last Activity: May 7 '07, 05:09 PM
Joined: Mar 15 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • tpecka
    replied to SQL server and MSDE
    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...
    See more | Go to post

    Leave a comment:


  • tpecka
    started a topic SQL server and MSDE

    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...
    See more | Go to post
No activity results to display
Show More
Working...