When I select “SQL Server Integration Services Package” as one of the job steps, SQL Agent gets to that step and hangs there ad nauseam.
What should take minutes has yet to complete. I’ve quit the job in the middle because of this, so no logging is provided other than letting me know that I’ve just cancelled the job.
I can run T-SQL steps and Powershell steps with flying colors.
I’ve created the package via “BIDS” Business Intelligence Development Studio, and clicked on “Save copy of package to..” and saved it to our SQL server. The job step points to the saved SSIS package.
Is there anything I’m doing wrong? Anything I should look at? How do I know where the SSIS package is in the process when running through SQL Agent?