ODBC Stage behaviour

harshada · Post by **harshada** » Thu Sep 15, 2011 2:36 am

This is not a query but wanted to share something which I was unaware of.

One of my jobs use ODBC stage to connect to Sybase db. Here the table definition has been imported from prod environment database. But the Datasource name, user pwd which are required to be mentioned in the 'Stage' tab of ODBC stage has the details of QA environment (different server than prod). I expected the job to point to QA database and run, but in fact it is pointing to prod d/b and running, as the table def has been imported from prod. Is this a obvious behaviour ?

ray.wurlod · Post by **ray.wurlod** » Thu Sep 15, 2011 6:18 am

Server job (as marked) or parallel job (as posted)?

harshada · Post by **harshada** » Thu Sep 15, 2011 6:47 am

Its a Server job

chulett · Post by **chulett** » Thu Sep 15, 2011 7:27 am

Moved.

Where the metadata was imported from makes no difference - as long as it is correct, of course. What it actually connects to depends on the connection being used, the odbc entry your stage specifies.

SURA · Post by **SURA** » Thu Sep 15, 2011 6:13 pm

Try to use the ODBC in the administrative tool (Windows) and try to connect the DB and ensure which DB it is trying to connect.

The same DB the job will connect!!

DS User

DSXchange

ODBC Stage behaviour

ODBC Stage behaviour

Re: ODBC Stage behaviour