There is a package imports data from MySQL server to SQL Server. The Package connects to the linux server through ODBC connection. But recently MySQL IP address been changed. After changing IP in ODBC connection, the package is still failing to run inside the job. Meanwhile it runs when I run it manually.
I can't figure it out what's going wrong. Tried to create new job, still the same. The error inside the job indicates that it's refering to the old IP address. But within package I didn't include IP address anywhere. It just uses connection through ODBC. Any help is appreciated.