Prev: SQL 2005 -- export table to a "fixed width" flat file -- Posting again
Next: float vs decimal
From: Mindaugas on 21 Nov 2006 11: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!

From: Mindaugas on 21 Nov 2006 12:06
I ended up exporting to a SQL2k db and then backing up that.

 | 
Pages: 1
Prev: SQL 2005 -- export table to a "fixed width" flat file -- Posting again
Next: float vs decimal