January 11, 2010 at 4:20 pm
I have a Data Flow Task that is importing a dBase file (.DBF) into a SQL Server table. When used for a single file the task works perfectly. However, when I try to use it within a Foreach Loop I get the following error:
"[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DBASEBRAINARD VFILES" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed."
I have used the same scenario to loop through and import Excel files succesfully in the past and as I said the process works when the task is run by itself. I have tried two different connection strings both with and without the User ID and Password and there is no difference.
I already have the Run64BitRuntime property set to False.
Can anyone shed some light into what is going on here? I have to import data from hundreds of these files.
Any help will be greatly appreciated.
January 11, 2010 at 4:52 pm
It looks like the connection manager properties are not being set correctly by the values returned from the for each loop container. Have you tried to toggle the debug breakpoint on your data flow task and check out the connection manager relevant variables prior to the execution entering the data flow?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply