Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

Issue with SSIS packages not completing when run via a SQL job

I have created a number of SSIS packages that run fantastically through Visual Studio.  However, when I add a number of these packages into one sequential SQL job, the job never completes.  It does not error but just remains in an "executing" state when looking at the job activity monitor.  I have no clue why they would run fine when executed in VS but never complete when executed in SQL.  Not all jobs fail in SQL.  I have other jobs which contain SSIS packages which run fine in SQL so I think the configuration is alright.  I need to supply more information but don't know where to start so any assistance or request for more detail will be greatly appreciated.
0
m12white
Asked:
m12white
1 Solution
 
sbagireddiCommented:
You need to check at which step it is stuck.
Just isolate that step and check what statements it is executing.
Also are there any jobs, processes running at that moment which are causing a resource conflict.

The way it looks it may be a scheduling issue.

Try all this.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now