Text File not showing up in destination list

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Text File not showing up in destination list

Author

Topic

cedubose
Starting Member

22 Posts

Posted - 2006-04-10 : 15:44:22

I am trying to export a database table to a flat text file, but it is not showing up as an option in the list of destination types.

Here are the types that are showing up:

MediaCatalogDB Ole DB Provider
MediaCatalogMergedDB OLE DB Provider
MediaCatalogWebDB OLE DB Provider
Microsoft Access
Microsoft Excel
Microsoft OLE DB Provider for Analysis Services 9.0
Microsoft OLE DB Provider for Data Mining Services
Microsoft OLE DB Provider for Internet Publishing
Microsoft OLE DB Provider for OLAP Services 8.0
Microsoft OLE DB Provider for Oracle
Microsoft OLE DB Provider for Outlook Search
Microsoft OLE DB Provider for SQL Server
SQL Native Client
SQLXMLOLDDB
SQLXMLOLDDB4.0
VSEE Versioning Enlistment Manager Proxy Data Source

It seems like there are a lot missing.

I'm trying to do this on SQL Server 2005 Developer Edition. I'm running Windows XP pro SP2.

Any thoughts?

Cynthia

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-04-10 : 20:48:28

You should have a 'Text File' option when you use the Export wizard. Perhaps try installing the most recent MDAC (Ms Data Access Components) and that might fix it.

You can also use BCP if you like command line interfaces....

HTH,

Tim

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources