December 7, 2007 at 1:40 pm
Hi
i need to create a job stream with more than 50 steps at a server.This job already exists in another server.I created a script of the existing job and executed it against the other server.It is giving a lot of error messages.
Is there a way to do this other than going through the wizard where i need to add the 50 steps manually from SQL server integration services?
Thanks in advance.
December 12, 2007 at 1:16 pm
If it's the same error I've encountered in the past, it's because the step command (enclosed in single quotes ') spans multiple lines in the script.
What I usually do is edit the sql and make sure the entire command is on one line. Run the sql, get the error, double click the error and it places you on the line in error. Modify the code and repeat.
Once the is created, you'll have to edit it to make sure you don't have any 'GO' commands not in column 1.
It's slightly time consuming, but less than recreating the job manually.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply