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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-01-17 : 21:36:46
|
| Hi All,I have a flat file named as Sec_Role.txtThe inputs are likeRole_Id Role_name 1 A2 BBut I just wanted to move the records in Sql Server Sec_role table.How can i do thru BCP Utility. I just want to send this script into my clients place. So i have go to bcp utility.Can anyone able to help me please..!Thanks and regardsKrishnakumar. |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-01-18 : 00:03:48
|
| http://msdn2.microsoft.com/en-us/library/ms162802.aspxThe url above is how to use the bcp utility, but I always use the openrowset function it's described in the below url.http://www.databasejournal.com/features/mssql/article.php/3584751 |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-18 : 07:12:53
|
| Imports usually use bulk insert rather than bcpsomething likebulk insert mytbl from 'c:\Myfile.txt' with (fieldterminator=' ')==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
BCP