I want to do a simple DTS export of a database. From a SQL 2005 database,
export it to Access or Excel (both 2003)

I'm running on Windows Server 2003 SBE

I create a blank Access/Excel file and am unable to export to either Access
or Excel.

The DTS Errors I recieve when exporting to Excel are:

Messages
Error 0xc0202009: {63638E90-7255-4929-8DA8-7643757265C9}: 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 "DestinationConnectionExcel" failed with error code
0xC0202009.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Destination 64 - Parameter"
(11374) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

The Errors when exporting to Access are... This happens on EVERY Column in
Every table:
Validating (Error)
Messages
* Error 0xc02020f6: Data Flow Task: Column "AlertPriority" cannot convert
between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)

AND finally fails with this one:

* Error 0xc004706b: Data Flow Task: "component "Destination - Alerts" (100)"
failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
--
alan

I am having the same problem.. have you found any resolution?

\\Lisa-Marie


LoanXEngine wrote:

I am also having this problem. Has anybody found how to resolve this
issue?

LisaMarieT (AT) gmail (DOT) com wrote: