Execute stored procedure without input link
Moderators: chulett, rschirm, roy
Execute stored procedure without input link
Hello -
I need to execute to execute a stored procedure that only inserts into a job log then run my etl job. All my input parameters for the stored procedure are job parameters. I am trying to figure out how to execute a stored procedure while passing job parameters and then begin to load the data any help? I have created a stored procedure stage for the sp
thanks
I need to execute to execute a stored procedure that only inserts into a job log then run my etl job. All my input parameters for the stored procedure are job parameters. I am trying to figure out how to execute a stored procedure while passing job parameters and then begin to load the data any help? I have created a stored procedure stage for the sp
thanks
Use an input link. Start from a Transformer, adding a dummy stage variable so it will compile and a constraint of "OUTROWNUM=1" so it only generates one row. Set your job parameters into fields in the input link so they can be easily passed to the stored procedure.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I was about to compile and insert into the job log so my two questions is this.
1. Since i am only passing one row into the stored procedure, how do i tell the transformer to only pass one row to the stored procedure?
2. After the stored procedue completed how do i tell it to continue on to uploading the data file
1. Since i am only passing one row into the stored procedure, how do i tell the transformer to only pass one row to the stored procedure?
2. After the stored procedue completed how do i tell it to continue on to uploading the data file
I was about to compile and insert into the job log so my two questions is this.
1. Since i am only passing one row into the stored procedure, how do i tell the transformer to only pass one row to the stored procedure?
2. After the stored procedue completed how do i tell it to continue on to uploading the data file
1. Since i am only passing one row into the stored procedure, how do i tell the transformer to only pass one row to the stored procedure?
2. After the stored procedue completed how do i tell it to continue on to uploading the data file