My SQL Server Import and Export Wizard Error

Asked By hazelwlee 10 points N/A Posted on - 01/08/2013

In my SQL Server Import and Export Wizard, I encountered the following error. 

The error is as follows,

“- Pre-execute (Error)
Messages
* Error 0xc0202009: {97D241BA-4215-4D82-A8CE-716288708210}: 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: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)

* Error 0xc004701a: Data Flow Task: component "Source 32 – wp_bp_messages_messages" (2627) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)”

Can you help me fix this error up. I am totally exhausted with this error.

Please help me.

• Status: Open
• Question Views: 1196
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Shifflett Laurel 0 points N/A #195319

My SQL Server Import and Export Wizard Error

Hellow Hazelwlee!!

I am not confirmed about the reason of your problem .But I can suggest for another way.

I would like to say that SQL Server 2005  introduces a new transformation tool named SQL Server Integrated Services (SSIS). SSIS is much improved over the old DTS. It is used to  import and export wizard to transfer data to and from SQL Server.

There are a number of different ways to start the SSIS Import / Export wizard. You can start it a couple of ways using the SQL Server Business Intelligence Development Studio. Or you can start it using the SQL Server Management Studio. Lastly, you can start it using an executable.

For learning in details please go to this link

Thanking you

Shifflet Laurel

 

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/19/2013
• Question Category: MySQL Server