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
 General SQL Server Forums
 New to SQL Server Programming
 Export Fixed Width File

Author  Topic 

GhantaBro
Posting Yak Master

215 Posts

Posted - 2009-07-19 : 16:04:30
Is there a way to export fixed width flat file without using the format file... The table that will be used to export will be created by dynamic sql with each field of size varchar(255)...I need to create flat file using that table but I want the size of each field to be the max len of that field... I don't know the actual size of the data and wont know the fields. Thanks!

GhantaBro
Posting Yak Master

215 Posts

Posted - 2009-07-20 : 10:09:09
bumping this up...
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-07-20 : 10:42:18
How does your export look if you don't know the fields?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -