DSXchange

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 ?

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

Its a Server job

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.

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