FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

Import to SQL Server from Access

I'm following the instructions on importing to SQL from Access and using the SQL Server Management Studio. When I click finish it gets the following errors when it gets to the Validating stage:

- Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "ixArea".
 (SQL Server Import and Export Wizard)
 
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task: "component "Destination 1 - Area" (90)" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task: There were errors during task validation.
 (SQL Server Import and Export Wizard)
 
Not sure what it means by "Read Only Column ixArea"

How can I get my Access database imported to SQL?
Phil Sherwood Send private email
Wednesday, October 22, 2008
 
 
I found that I needed to Select all tables and then Edit Mappings to enable "Allow identity inserts"

This fixed the problem.
Phil Sherwood Send private email
Wednesday, October 22, 2008
 
 
New Error.  Now I get the following when importing to SQL from Access:

Messages
Error 0xc0202009: {DCC3CB82-42A1-40E3-BBC0-7B0D3E1C47F0}: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".
 (SQL Server Import and Export Wizard)
 
Error 0xc020801c: Data Flow Task: 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.
 (SQL Server Import and Export Wizard)
 
Error 0xc004701a: Data Flow Task: component "Source 64 - WikiPageView" (4659) failed the pre-execute phase and returned error code 0xC020801C.
 (SQL Server Import and Export Wizard)
 

How can I fix this?
Phil Sherwood Send private email
Wednesday, October 22, 2008
 
 
Sounds like the DTS version of "login failed" - check login privileges.
Andrew Davies Send private email
Thursday, October 23, 2008
 
 
Or if you don't have any wikis set up, you can just skip copying those tables.  (WikiPageView)
Michael H. Pryor Send private email
Thursday, October 23, 2008
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.