Hi, I've got a masterpackage with makes Loops over folders to load files. In the masterpackage I have to parallel Loops. By using just one Loop everything workes fine. If I join another one I get a error while loading files: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnection" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. This error appears by loading either exel or txt files in the subpackages. Here I'm using a OLE DB Connection with the ConnectionString dynammically set to Data Source=SERVER;Initial Catalog=AdventureWorksDW;Provider=SQLNCLI10.1;Integrated Security=SSPI; Has anybody a idea what's going wrong? Thanks for your help!

If you are using an OLE DB connection in the subpackages, how come you have an error on an ODBC driver?MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

I found the error. I made a mistake by defining the connectionstring in the masterpackage. Thanks or your help! @Koen Verbeek: I didn't understand the errormessage. I never used a ODBC driver.

How do you build the connection string in the client paackage? It seems to be incorrect...