i have problem with my Jobs on SQL Server 2005 Agent, when i run the jobs i see status of the jobs is "EXECUTING" but its look not process the package, because the package should be running only for 1 menit, but the SQL Server Agent jobs stil on EXECUTING status after i wait for along time and i need cancel the jobs to stop the jobs .
this My Condition
1. i need to tranfer data form oracle to sql server 2005
2. i create integration service package
3. i am using Proxies to run schedule
please help me ...