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 2005 Forums
 SSIS and Import/Export (2005)
 how to create a *.fmt file?

Author  Topic 

sqlstepp
Starting Member

1 Post

Posted - 2010-03-10 : 13:28:02
i need to import from a text file having fixed length columns.
i am new to BCP and format files. i learnt how the format should look like, but i dont know where to go and create one such file and how to save it.

please explain.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2010-03-11 : 00:54:39
search in books on line for BCP. they have a sample script in the Examples.. cant remember it off the top of my head..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -