Execute stored procedure without input link

chulett · Post by **chulett** » Wed Oct 29, 2008 2:23 pm

I hope so, seeing as I'd already spelled that out.

1. Automatic.
2. Automatic.

aasaif · Post by **aasaif** » Wed Oct 29, 2008 2:25 pm

Yes i tried that someone chulett earlier i must have not seen something earlier but it works.

So is the only way to run the rest of the job after i insert the entry into the job log is to connect the stored procedure stage to a transformer and then output the transformer to the rest of the job?

Also at the end of the job how do i maintain the flow to insert one row into the job entry table that the job complete

aasaif · Post by **aasaif** » Wed Oct 29, 2008 2:26 pm

Yes i tried that chulett recommended it earlier i must have not seen something earlier but it works.

So is the only way to run the rest of the job after i insert the entry into the job log is to connect the stored procedure stage to a transformer and then output the transformer to the rest of the job?

Also at the end of the job how do i maintain the flow to insert one row into the job entry table that the job complete

chulett · Post by **chulett** » Wed Oct 29, 2008 2:32 pm

Rather than pulling teeth, why not lay out all that you needed to do from the beginning? Yes, link everything together and the row should flow through each stage.

dslisa · Post by **dslisa** » Wed Oct 29, 2008 2:37 pm

Aasif, are you trying to use output from Stored Proc 1 as input for Stored Proc 2?

aasaif · Post by **aasaif** » Wed Oct 29, 2008 2:46 pm

nope they having nothing to do with each other this is the flow basically
job paramters set to a stored procudure (insert into a job log job started)
then i have sequential file passed into a stored procedure
last i insert a row stating job completed of if i have any rows rejected jobs completed with errors.

So ill just connect it with the transformer to the other job with a dummy input and output row.

Then ill figure out how i insert a row into the job log at the end because i dont want that process being called at the row level

chulett · Post by **chulett** » Wed Oct 29, 2008 3:18 pm

Since you're only passing one row through, then that row equals "the end" does it not? Otherwise, consider doing it "after job", which means a routine or a script.

aasaif · Post by **aasaif** » Thu Oct 30, 2008 7:23 am

one row is loaded into the job log
however then i load thousands of rows in an etl job then i would like to insert one row into the job complete after those rows are loaded
So i guess your saying i have to build a routine.

chulett · Post by **chulett** » Thu Oct 30, 2008 7:30 am

Or run a link to an Aggregator set to 'Last', it will send a single row back out after the final row has been processed.

aasaif · Post by **aasaif** » Thu Oct 30, 2008 7:44 am

i like that idea. I will try it

aasaif · Post by **aasaif** » Thu Oct 30, 2008 7:46 am

i like that idea. I will try it

aasaif · Post by **aasaif** » Thu Oct 30, 2008 9:19 am

Can you give me a little more detail on how this is done.

So after my stored procedure i send a link to a transformer which will be done on each row however then in the transformer i send a link to the aggregator stage .

Where in this stage does it allow you to specify last row i dont see it?

chulett · Post by **chulett** » Thu Oct 30, 2008 10:01 am

It's one of the derivations on the output columns that you don't group by. Put a dummy column for the Aggregator, then in the following transformer include the fields you need. That or run them through the Aggregator.