Post reply

SSIS Agent Job Problem..

  • June 28, 2012 at 12:42 pm

    #263505

    Hello All,

    I have an SSIS package that will load the data from Oracle to SQl tables.

    When I run it from BIDS or from SSIS package store, it works fine but when I run it from SQL agent job, it fails.

    Can any one help me.

    Thanks,

  • June 28, 2012 at 2:29 pm

    #1506844

    What error is the agent reporting?

    My first suspicion would be that the SQL Agent does not have permissions to query the Oracle server.

  • June 28, 2012 at 3:09 pm

    #1506863

    Thank you for your reply.

    Your guess is almost correct, my problem is the Oracle source that I am calling is not in TNS file, my DBA told me that and we changed it.

    Now ,its working fine.

    Thank you,

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

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