DSXchange

Hi

In one of the jobs where I am just fetching some data from oracle table and inserting/updating it to sql server table. But whenever I run the job it just remain in running condition only and nothing happens. it it is not pulling data from oracle also. The last message in log I can see is

main_program: Starting step execution.


Any idea what exactly is happening ? How can I resolve this ?

Thanks in advance

Replace your target sql server stage with a Peek statement. Does your new job hang? If not, you need to check your sql server stage, otherwise you need to check your source SELECT statement.