BCP - Bulk Inserting / Copying to Sql

11/15/2011 18:41 whyt3boi#1
So I've asked for help a few days ago on this subject of inserting textdata from the media. And replies were related to Bulk Inserts using BCP.

I do realize that some people are conservative on how much they want to tell the community due to competition.

So all bullshit aside. So we don't make any mistakes to the database or other files I need someone to share their method of using Bulk Inserting through BCP or other Sql Import tools.

Use an example of a textdata file and where it needs to be imported.

I do understand some have said _ObjCommon is used for Media/server_dep/silkroad/textdata
11/15/2011 18:48 jangan322#2
idk what you are asking for exactly but this might help you.
Credits to Artuuro.

Quote:
use SRO_VT_SHARD // change the db name
BULK
INSERT _RefSkill // change your table name
FROM 'C:\Users\Artuuro\Desktop\enc\Skilldata_35000enc.t xt' // Edit this to your location
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)
11/17/2011 20:21 Unrealx420#3
Quote:
Originally Posted by jangan322 View Post
idk what you are asking for exactly but this might help you.
Credits to Artuuro.
Quote:
use SRO_VT_SHARD // change the db name
BULK
INSERT _RefSkill // change your table name
FROM 'C:\Users\Artuuro\Desktop\enc\Skilldata_35000enc.t xt' // Edit this to your location
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)
would be nice if this actually worked..