You are here: Export SQL05 data to Access « MsSQL Server « IT news, forums, messages
Export SQL05 data to Access

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация