I have an SSIS package which runs fine in debug mode from Visual Studio, however if It runs as a SQL Server job it hangs at step 2 which takes about twenty minutes in Visual Studio. The only thing I can think it could be is the SQL Server job itself.
The shutdown interval is set to 15 seconds in the SQL Server Agent. Could that cause the job to suspend?
Any help appreciated.
Thanks to everyone who helped. I created a new Job on the SQL Server and the package seems to be running fine.
User contributions licensed under CC BY-SA 3.0