DSXchange

Posted: **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

Posted: **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).

Posted: **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'.

Posted: **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.

Posted: **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