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.
| Author |
Topic |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2010-03-29 : 08:33:54
|
hi All,plz help me in correcting the syntax for creating .fmt filebcp mydb.dbo.mytable format nul -c -f \\266A\ProjectZ\C204\Sys_Ext\mytable.fmt -T once I create the fmt file, with the help of this, I have to load a file(1gb) into a table.Regards,aak |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-03-29 : 08:39:26
|
| You haven't specified SQL Server name. Use -S option.Harsh Athalyehttp://www.letsgeek.net/ |
 |
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2010-03-29 : 08:54:43
|
| Thanks Harsh,so how the corrected syntax looks like?Regards,aak |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-03-29 : 09:00:33
|
| [code]bcp mydb.dbo.mytable format -c -f\\266A\ProjectZ\C204\Sys_Ext\mytable.fmt -S myserver -T[/code]Harsh Athalyehttp://www.letsgeek.net/ |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2010-03-29 : 09:11:02
|
After providing -S it saysbcp mydb.dbo.mytable format nul -c -f \\266A\ProjectZ\C204\Sys_Ext\mytable.fmt -T -SUser name not provided, either use -U to provide the user name or use -T for Trusted Connection |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
help needed in creating .fmt file