cannot import mdf and dakpack files into sql server developer 2014 64 bit
hi. a blind it student, and was using windows 8.1 , but rrolled back to windows 7 64 bit pro. now got sql server developer 2014, 64 bit, and now i cannot imnport my mdf files, or my dacpack, created for an assignment. and also cannot import the adventure works 2014 or 2012. using visual studio 2015 community edition and was able to create a connection, but only the local version, and now just tried to use the 32 bit import wizard, almost got to the end, then it said it stopped working and then debug or close. any work arounds. using a screen reader jaws for windows from http://www.freedomscientific.com. any other more accessible interfaces or other programs to work around, just want to import my databases. Also i tried using create new database in sql management studio, but said the file name was empty when i typed it in. frustr
September 8th, 2015 12:24am

Hi Marvin,

Do you have ldf file of your database? If you have ldf file, you can attach the database to SQL Server 2014 by using SQL Server Management Studio or T-SQL. For more detailed steps, please review this article.

However, if you do not have the ldf file, please attach mdf file following the steps in this blog. And if you get any errors when attaching mdf file, please help to post the full error message for analysis.

In addition, could you please describe more details about dakpack files? If you want to import a data-tier application (DAC) file(a .bacpac file) into SQL Server , you can review the steps in  this article.

Thanks,
Lydia Zhang

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 2:02am

hi. well get the errors, trying to import microsoft access, and getting errors, cannot import, duplicate errors. so, can you help. had to reinstall sql server, was able to add the adventure works and import my backfile for a previous school project, able to import the .bak file. now, cannot import the database microsoft access which i created, a accc and then saved it as a .mdb. any help. using sql server developer 2014 64 bit windows 7 pro 64 bit. any help.
September 11th, 2015 2:10am

Hi Marvin,

Could you please post the full error message that you get or share us a screenshot? When importing data from Access 2003 database to SQL Server 2014, please select Microsoft Access as data source and follow the steps in this similar blog to import data.

Thanks,
L
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 2:23am

HI. HERE'S THE ERROR REPORT.

WILL PASTE BELOW.

HOW TO FIX.

MARVIN.

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Success)

- Pre-execute (Success)

- Executing (Success)

- Copying to `DailyNames` (Error)
Messages
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E2F.
An OLE DB record is available.  Source: "Microsoft Access Database Engine"  Hresult: 0x80040E2F  Description: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.".
 (SQL Server Import and Export Wizard)
 
Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Destination - DailyNames.Inputs[Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "Destination - DailyNames.Inputs[Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 

- Copying to `DailyPrices` (Error)
Messages
Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - DailyNames" (28) failed with error code 0xC0209029 while processing input "Destination Input" (41). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020c4: Data Flow Task 1: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
 (SQL Server Import and Export Wizard)
 
Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Source 1 - DailyPrices returned error code 0xC02020C4.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E2F.
An OLE DB record is available.  Source: "Microsoft Access Database Engine"  Hresult: 0x80040E2F  Description: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.".
 (SQL Server Import and Export Wizard)
 
Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Destination 1 - DailyPrices.Inputs[Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "Destination 1 - DailyPrices.Inputs[Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination 1 - DailyPrices" (99) failed with error code 0xC0209029 while processing input "Destination Input" (112). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 

- Post-execute (Success)
Messages
Information 0x4004300b: Data Flow Task 1: "Destination - DailyNames" wrote 0 rows.
 (SQL Server Import and Export Wizard)
 
Information 0x4004300b: Data Flow Task 1: "Destination 1 - DailyPrices" wrote 0 rows.
 (SQL Server Import and Export Wizard)
 

September 11th, 2015 2:34am

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

Other recent topics Other recent topics