how to load text file into single row ?

[alex]

Hi
how to load text file into single row

I already created dts using
Read File Transformation to place
data in to buffer table then
update row in main table

Is Any way to do it without using DTS , just with T- Sql or bcp ?

[Rawhide]

Yes, which part of your process is it you need help figuring out how to run?

BCP in data from text file into buffer table and then update the data inteh main table.

Use xp_cmdshell to execute BCP.

Just curious, but why the desire to eschew DTS?

[alex]

read data from file is part of stored procedure.
If I use dts I have copy dts and procedure to production.

[rmiao]

You can load data from text file with bulk insert in query analyzer or with bcp in dos.

[nosepicker]

Also, did you want your text file to be in a single row, or a single column as well? If you wanted it to be self-contained in a single row and column, your target table should have a column with a datatype of "text". As long as your textfile is less than 2GB in size, it should fit in there.