Reputation: 1
i can't run a foreach loop container for an ADO NET Source contains a paradox files
I have a lot of paradox files (*.db), i want to automatize the transfer of data containing on these files to sql server, with ado net source it works, but foreach loop doesn't.
I have configured the Foreach Loop Enumerator to use an enumerator type of Foreach ADO.NET Schema Rowset. The error it throws is
The new connection, Paradox, is not an OLE DB connection so it can not be used by the schema rowset enumerator and therefore, will not be added to the connections list
i tried ole db source but it doesn't work. foreach loop needs an ole db source, but when i use ole db source it doesn't read the file prompting an error. is there a way to work with foreach loop using ado net source? some help, if you please. Thank you.
Is there a way to work with foreach loop using ado net source?
During execution, I receive the following error
Opening a rowset for "VD010120" failed. Check that the object exists in the database.
Upvotes: 0
Views: 314
Answers (0)
Related Questions
- SSIS Foreach Loop Container to read files and load into DB getting crash during execution
- Multiple foreach loop containers in SSIS
- ssis error : foreach in foreach loop container
- SSIS Foreach Loop Container only goes through 1 iteration in design environment
- Foreach Loop Container gives an error after 5 iterations. SSIS
- ForEach Enumerator has failed with error 0x80131509 "(null)"
- Foreach Loop Container ERROR: [Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER........"
- Need Help to set up Package that contains Foreach Loop container SSIS
- Foreach Loop Container in SSIS
- Foreach Loop Container failed to traverse through all files in a folder