|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Hi,
How is it possible to create a .fmt file with the following informations if they are required? server1 database1 table1 Thanks bcp pubs..authors2 in
c:\new_auth.dat -fc:\authors.fmt -Sservername -Usa -Ppassword Read Using Format File article in the bol"farshad" <fars***@discussions.microsoft.com> wrote in message Show quoteHide quote news:A9363EE5-807D-4BCB-9C2D-BC7ABCEDFB10@microsoft.com... > Hi, > How is it possible to create a .fmt file with the following informations > if > they are required? > server1 > database1 > table1 > > Thanks Hi,
Does this mean I have to have a .dat file? How do I create it? P.S. I run the bcp to insert using bulk insert. Thanks Show quoteHide quote "Uri Dimant" wrote: > bcp pubs..authors2 in > c:\new_auth.dat -fc:\authors.fmt -Sservername -Usa -Ppassword > Read Using Format File article in the bol"farshad" > <fars***@discussions.microsoft.com> wrote in message > news:A9363EE5-807D-4BCB-9C2D-BC7ABCEDFB10@microsoft.com... > > Hi, > > How is it possible to create a .fmt file with the following informations > > if > > they are required? > > server1 > > database1 > > table1 > > > > Thanks > > > Hi
On SQL 2000 BCP has a format option that will create a format for you, see Books online for more. John Show quoteHide quote "farshad" <fars***@discussions.microsoft.com> wrote in message news:31F50883-0BF3-49B9-BB17-A45EB192F489@microsoft.com... > Hi, > Does this mean I have to have a .dat file? How do I create it? > P.S. I run the bcp to insert using bulk insert. > Thanks > > "Uri Dimant" wrote: > >> bcp pubs..authors2 in >> c:\new_auth.dat -fc:\authors.fmt -Sservername -Usa -Ppassword >> Read Using Format File article in the bol"farshad" >> <fars***@discussions.microsoft.com> wrote in message >> news:A9363EE5-807D-4BCB-9C2D-BC7ABCEDFB10@microsoft.com... >> > Hi, >> > How is it possible to create a .fmt file with the following >> > informations >> > if >> > they are required? >> > server1 >> > database1 >> > table1 >> > >> > Thanks >> >> >> I would have if I could find it in books online.
Thanks Show quoteHide quote "John Bell" wrote: > Hi > > On SQL 2000 BCP has a format option that will create a format for you, see > Books online for more. > > John > "farshad" <fars***@discussions.microsoft.com> wrote in message > news:31F50883-0BF3-49B9-BB17-A45EB192F489@microsoft.com... > > Hi, > > Does this mean I have to have a .dat file? How do I create it? > > P.S. I run the bcp to insert using bulk insert. > > Thanks > > > > "Uri Dimant" wrote: > > > >> bcp pubs..authors2 in > >> c:\new_auth.dat -fc:\authors.fmt -Sservername -Usa -Ppassword > >> Read Using Format File article in the bol"farshad" > >> <fars***@discussions.microsoft.com> wrote in message > >> news:A9363EE5-807D-4BCB-9C2D-BC7ABCEDFB10@microsoft.com... > >> > Hi, > >> > How is it possible to create a .fmt file with the following > >> > informations > >> > if > >> > they are required? > >> > server1 > >> > database1 > >> > table1 > >> > > >> > Thanks > >> > >> > >> > > > Hi
Try the online copy: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_bcp_61et.asp John farshad wrote: Show quoteHide quote > I would have if I could find it in books online. > Thanks > > "John Bell" wrote: > > > Hi > > > > On SQL 2000 BCP has a format option that will create a format for you, see > > Books online for more. > > > > John > > "farshad" <fars***@discussions.microsoft.com> wrote in message > > news:31F50883-0BF3-49B9-BB17-A45EB192F489@microsoft.com... > > > Hi, > > > Does this mean I have to have a .dat file? How do I create it? > > > P.S. I run the bcp to insert using bulk insert. > > > Thanks > > > > > > "Uri Dimant" wrote: > > > > > >> bcp pubs..authors2 in > > >> c:\new_auth.dat -fc:\authors.fmt -Sservername -Usa -Ppassword > > >> Read Using Format File article in the bol"farshad" > > >> <fars***@discussions.microsoft.com> wrote in message > > >> news:A9363EE5-807D-4BCB-9C2D-BC7ABCEDFB10@microsoft.com... > > >> > Hi, > > >> > How is it possible to create a .fmt file with the following > > >> > informations > > >> > if > > >> > they are required? > > >> > server1 > > >> > database1 > > >> > table1 > > >> > > > >> > Thanks > > >> > > >> > > >> > > > > > > farshad wrote:
> I would have if I could find it in books online. What is it you can't find? Try to look for bcp in Books On Line. That > Thanks > will give you a number of "hits" - and also about bcp.fmt. Regards Steen  
Other interesting topics
Database disappeared from sysdatabases after running out of file space
system_function_schema License Questions Working with a SAN for 2-4 TB database 2005 dts package question SQL2005 x86-x64 performance comparison How can I transfer Data From Access? How do I Modify a Stored Procedure? DBCC FREEPROCCACHE database naming |
|||||||||||||||||||||||
