The most elegant way to import flatfiles into SQL server 2005 without using SSIS

Question

For some reasons, SSIS is not avalialble.

I read about OPENROWSET, but I will have others problem from on the format file and path of file.

How can I do it in a elegant way?

Answer 1

You can always use bcp utility

It's been around since the earliest versions and is very easy to use.