July 2, 2010 at 12:31 am
I am attempting to import from an Access database that has workgroup security into an SQL Server 2008 database using SSIS.
I've had endless problems....I've finally got the correct user to execute the package but now the workgroup authentication seems to be the problem. I get the error below, btw the workgroup file exists and no one is using it.
Source: Import_Biospecimens Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80040E4D Description: "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.". End Error Error: 2010-07-02 15:14:44.20 Code: 0xC020801C Source: Data Flow Task 2 - Lookup Tables Source 3 - tlkpProcessedBy [285] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2010-07-02 15:14:44.20 Code: 0xC0047017 Source: Data Flow Task 2 - Lookup Tables SSIS.Pipeline Description: component "Source 3 - tlkpProcessedBy" (285) failed validation and returned error code 0xC020801C. End Error Error: 2010-07-02 15:14:44.20 Code: 0xC004700C Source: Data Flow Task 2 - Lookup Tables SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-07-02 15:14:44.20 Code: 0xC0024107 Source: Data Flow Task 2 - Lookup Tables Description: There were errors during task validation. End Error
Can any one help!!!
July 2, 2010 at 2:16 pm
Pls check this link,
http://www.sqlservercentral.com/Forums/Topic946733-148-1.aspx
so set Run64BitRuntime = false of your project properties
RB
July 5, 2010 at 7:06 pm
I've already set Run64BitRuntime = false.
Any other solutions?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply