How to implement After and Before in ODBC stage

Sridhar Sivakoti · Post by **Sridhar Sivakoti** » Mon Apr 30, 2007 3:00 am

Hi,

I want to implement a query(A), Before this query(A) I want to implement another query(B) and After query(A), I want to implement one more query(C).

In simple, like MSOLEDB stage(it consists Before and After tabs), I want to implement above logic in ODBC stage.

Please suggest me.

Regards
Sridhar

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 5:23 am

Three jobs in a job sequence. Job1 executes query A and has two triggers to Job2 (which executes query B) and to Job3 (which executes query C).

DSguru2B · Post by **DSguru2B** » Mon Apr 30, 2007 7:24 am

You can also use the OPEN and CLOSE commands in the enterprise stage. These properties are present under 'Options'.

baigdw · Post by **baigdw** » Thu Sep 13, 2007 3:00 pm

Just a thought .. Can't we use a custom sql with seperators for the 3 queries to be executed one after the other.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 13, 2007 3:15 pm

Try it. Let us know.

DSXchange

How to implement After and Before in ODBC stage

How to implement After and Before in ODBC stage

Re: How to implement After and Before in ODBC stage