My SSIS 2008 R2 package processing 55 excel files successfully in BIDS, but when I run the SSIS pacakge under Sql Serve Agent the job hangs with about 25 excel files processed. I notice their were a 15 excel.exe processes in the Windows Task Manager Processes tab. Does anyone have a solution? I would appreciate anyone's help.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.