Need some help with a sql job that lifts and shifts data from a sybase db to a sql one.
I have inherited a legacy piece of software which is based on a sybase db. I have had to migrate a job that goes into that db using a odbc dsn connector and extracts the data to a SQL DB.
I used VS to change the properties and connections and the stages work there ok. I have tested the connectors on the server and also in the job it self and all is ok. I did have some issue with it not working but this was down to setting the job to run in 32 bit mode which i have sorted.
However i am now getting a the following error when ever i try and run the job.
Pretty sure the password and user name is correct as the test connection are all ok?