LisaMarieT@gmail.com wrote:
> I am having the same problem.. have you found any resolution?
>
> \\Lisa-Marie
>
>
> LoanXEngine wrote:
> > 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