Bulk load problem from the file that does not have end line char

[Rosti]

Hello,
I would like to load from the text file that does not have an end line character ('\n')
Please help.
Thank you.

 

[gmmastros]

You may have better luck getting an answer if you post some sample data and explain the format.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[TheBugSlayer]

Do you know how to separate to detect the end of line otherwise? What' s in a line, a single-column record or multiple-column one? If there there is more than one column then how are the columns delimited, is this a fixed or variable size record?

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)

 

[Rosti]

Each record has multiple, variable lenght fields.
Here is the sample of the record:
1,Hayton,Rachelle,student,8008759555,,,

 

[gmmastros]

Are there the same number of fields in each record? If so, you could try importing the data in to a table with a single column and then pivoting the data once it's in SQL Server, and then finally inserting to your real table.

Just a thought.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[TheBugSlayer]

If the number of fields is the same in each record your problem can be solved easily, otherwise it' s going to be difficult to tell where one record ends and the other one starts.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)