Issue with SSIS packages not completing when run via a SQL job
Posted on 2008-06-20
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.