SQL Server import and export wizard - change concurrent setting

0

I am trying to export several (~40) tables using the SQL Server import and export wizard (Right click database -> Task -> Export Wizard).

The wizard allows me to export all tables from database, 1 by 1, without error.

However, when I want to export all tables together, there is an error. I guess it is due to a concurrency issue (because the screen shows 2 tables are exporting together).

Can I change concurrency settings of the wizard? (set maxconcurrentexecutables to 1 in SQL Server). Or, do I need to use SSIS?

The error message is below:

  • Pre-execute (Error) Messages Error 0xc0202009: Data Flow Task 2: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. (SQL Server Import and Export Wizard)

  • Error 0xc02020e8: Data Flow Task 2: Opening a rowset for "Table16" failed. Check that the object exists in the database. (SQL Server Import and Export Wizard)

  • Error 0xc004701a: Data Flow Task 2: Destination 7 - Table16 failed the pre-execute phase and returned error code 0xC02020E8. (SQL Server Import and Export Wizard)

sql-server
asked on Stack Overflow Jun 29, 2018 by Tony Chan • edited Jun 29, 2018 by EzLo

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0