Job fails after changing IP address

  • 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.

    Thanks.

  • Are you changing the correct ODBC driver? Have you created a user DSN and are changing that? Do do you have 32 & 64 bit versions of the ODBC driver and are changing the wrong one?

    Mack

  • You were right Mackers,

    All the time I was changing wrong DSN :w00t:. Forgot that the package works with system DNS only while running in job, and it uses User DSN while running in Visual Studio when you are using 64 bit Server.

    Thank you very much.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply