Hi !
I have question . I have asked it before but havent got reasonable answer.
After I run 5 Jobs with Sequencer . I want to Enter each of 5 Tables specific row with with specific key. I wrote sp but "Stored Procedure Stage" have to be with Output or Input Link and I want to run the sp and thatis it.
Any ideas how to do it ?
SQL Runing On Several Tables
Moderators: chulett, rschirm, roy
Maybe you haven't gotten a 'reasonable answer' because your question is practically incomprehensible.
Going off the "I want to run sp and thatis it" part, why not just write a batch file to call your sql tool of choice and execute the stored procedure? Run it from a Routine Activity stage in the Sequencer job using 'DSExecute'. For example, if Oracle then you would use 'sqlplus' to do the dirty work.
Does that seem reasonable?
Going off the "I want to run sp and thatis it" part, why not just write a batch file to call your sql tool of choice and execute the stored procedure? Run it from a Routine Activity stage in the Sequencer job using 'DSExecute'. For example, if Oracle then you would use 'sqlplus' to do the dirty work.
Does that seem reasonable?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: