Posted by chris.feyrer on 10/25/06 14:56

I need to export data from SQL server 2000 (or SQL server 2005 with a
db connection to the SQL 2000 server) to a DB4 file via DTS.

When I use Windows 2000 server to attempt the export, I keep getting an
error message saying that one of my columns does not exist from the
Server 2000 DTS, and don't even see an option for 2005 DTS export to
DB4 in the SQL Server Import and Export Wizard for SQL 2005.

I've been exporting the information to Excel and then saving as DB4,
but this introduces a whole 'nother set of issues.

Please let me know what can cause the error message on Windows 2000 DTS
export that can say a column does not exist; additionally, please let
me know if DB4 export is available at all on SQL server 2005, as I
don't see it as an option.

Thank you,

Christopher Feyrer

• Next in forum: Re: Help with an update query
• Prev in forum: .NET 2.0 and .NET 1.1 co-existence?
• Thread view: DBF file export issues onWindows 2000 SQL server w/ DTS/ SQL 2005 with DTS

[Reply to this message]