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)
 Exporting to Fixed Width Text with too many column

Author  Topic 

daviddeldave
Starting Member

28 Posts

Posted - 2005-11-02 : 09:02:46
Exporting to Fixed Width Text file of more than 255 columns is not possible. Is there any other recommended approaches rather than using DTS or is DTS capable of doing this but I am not aware of it.

Thanks

David

David Mercer

X002548
Not Just a Number

15586 Posts

Posted - 2005-11-03 : 11:00:02
Did you try bcp?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -