Posted by Mindaugas on 11/21/06 16:35
I'm trying to help a client export some data from SQL 2005 to an Access
database or even an Excel file. Either way I get an error like this:
- Setting Destination Connection (Error)
Messages
Error 0xc0204016: DTS.Pipeline: The "output column "press_release_body"
(1500)" has a length that is not valid. The length must be between 0
and 4000.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC0204016
(Microsoft.SqlServer.DTSPipelineWrap)
The ultimate goal is to be able to export this and import it into a SQL
2000 server, this client does not have SQL 2005, but the db they have
hosted is on a 2005 server. It is in compatibility mode 80 btw in the
options. Thanks!
Navigation:
[Reply to this message]
|