asked on

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.

SOLUTION

James Murrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

m12white

ASKER

Unsure. I've tried the SQL Agent under the administrators account. No change. It almost looks like a scheduling problem but these jobs were setup identically to a much smaller server running sql 2000 that ran this consolidated schedule just fine (albeit slowly). This server is a new and very powerful unit that I wouldn't expect to have problems with jobs running simultaneously.

SOLUTION

nmcdermaid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

m12white

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial