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.