OLEDB oracle connection in SSIS

  • Prakash T

    SSC Enthusiast

    Points: 128

    Dears, I have created a SSIS job to pull the records from Oracle. i m using OLEDB connection for oracle and pushing to SQL server. here when i manually run the package its working fine but the same package is scheduled for SQL server Agent job it keeps on running but no result even i have enabled logs nothing is available. simple task which takes 1 min to run manually which runs long time but no results in Agent jobs. (i have scheduled the job as file system)

  • crow1969


    Points: 2995

    Things to check here;

    1. Is there a pop-up or message box in the package.  SSIS will not get past this point.
    2. Can the SQL Server resolve the connect identifier?  This may lead to a timeout per connection.I sther

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

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