SSIS hangs when reading from Oracle source

  • kevin bacon

    SSC Veteran

    Points: 290

    I have a simple SSIS package.  Source is Oracle 12.  select col1, col2.,,, from oracle.table.  It uses Attunity driver.  Destination is SQL 2012.  Straight bulk insert.  Package hangs when running on server.  It doesn't error out, it just seats there for days, if I let it.  What I found out is:  in the source, if I do 
      select col1, col2.,,, from oracle.table WHERE ROWNUM < 10000,  the job runs fine.  I can play with the number, and it gets to a certain number, around 10,000, then it hangs. 
    Also, in the source select, if I do:
    select col1 from oracle.table WHERE ROWNUM < some integer, then I can get to a greater number of rows.  So by selecting less columns, I get more rows.  But it still hangs once I get to a certain point.

    Has anyone seen this?  It tells me this might have to do with some thing on the network.  But I have no idea what to do to fix it.

    THANKS!

  • kevin bacon

    SSC Veteran

    Points: 290

    I have since worked with the oracle dbas.  What we saw was nothing made its way to the oracle side.  When I executed the package from the SQL side, there was no activity on the oracle side other than a connection was made.  So we are thinking this has something to do with the network.  Ideas?

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

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