How to Import Text file with Caret '^' delimiter

Question

How to Import Text file with Caret '^' delimiter

rembersu-432095

Ten Centuries

Points: 1300
More actions
December 22, 2008 at 6:46 pm

#195367

Hi All,
Can you please advise How to Import Text file with Caret '^' delimiter data format. The import/export wizard does not show the Caret delimiter option.
Thanks in Advance.
Rembersu

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Lookup BULK INSERT in Books OnLine.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

rembersu-432095 Ten Centuries Points: 1300 More actions · Answer 2

Hi,

Thank you for your reply . I have tried bulkinsert and it works with the below syntax for the caret delimited file. i was trying to create a ssis package which will load the files on regular basis. is there any way that i can make it work for SSIS.

BULK INSERT testdb.dbo.testload

FROM 'c:\test\testload.csv'

WITH

(

FIELDTERMINATOR ='^',

ROWTERMINATOR = '',

FIRE_TRIGGERS

)

Thank & Regards

Rembersu

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

You may want to move this thread to the SSIS forum then.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

rembersu-432095 Ten Centuries Points: 1300 More actions · Answer 4

Thank you. I have post the request in the SSIS Forum.

Thank you

Remebersu

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 5

rembersu (12/22/2008)
Hi All,
Can you please advise How to Import Text file with Caret '^' delimiter data format. The import/export wizard does not show the Caret delimiter option.
Thanks in Advance.
Rembersu

try with BCP / SQLCMD command for more info see SQL BOL.

Walter Tucholski Ten Centuries Points: 1262 More actions · Answer 6

If you want to use SSIS just use the caret as the column delimiter for the input file. It will not show as an available choice from the drop down so just type it in.