Flat file processing dilemma

Hello,

How do I import data from a text file into columns (DB_table) that I have created in SQL server 2005?

Data in text file does not have any commas, semicolons, or spaces in between them.

Each instance in the text file consists of 109 characters (real numbers).

I also know that first 4 numbers go in particular field, next 4 go in another field, and next 6 are particular field, and so on.

I also have created columns in a table respectively.

Ravi,

have you tried using Fixed Width (or Ragged Right if you have row delimiters) format to process your files?

|||Use a fixed width file format and your problem is solved.