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?
![Confused :?](./images/smilies/icon_confused.gif)
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: