SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SSIS FOREACH LOOP showed error after all the files are looped through
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 86%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DDUC
1
Reputation point
Hi,
I am having an issue with foreach loop in on of my SSIS package. After all the files were loaded from unprocessed folder and moved to processed folder, it supposed to stop the loop and moved to the next step. However, In my case the loop kept running and I got a message saying that "[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed."
It seems like it trying to find the files in the folder but since it is empty hence this error. " Any helps would be greatly appreciated. Thanks
SQL Server Integration Services
{count} votes
-
ZoeHui-MSFT 41,536 Reputation points2022-12-19T07:48:19.157+00:00 Hi @DDUC ,
Check below link to continue a Foreach loop after an error.
https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/
Sign in to comment
Sign in to answer