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 ?
ODBC Stage behaviour
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: ODBC Stage behaviour
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
The same DB the job will connect!!
DS User