SQL Exporting to Text file problem, rows are merging together

[grayt26]

Hi All,

I am exporting a SQL table to a text file, comma delimited. The text file is approx 4.5g in size. After several attempts i am noticing that there is a record each time that is being merged with another record.

A better way of explaining that is one record looks like it has been appeneded to the end of the last record doubling the length of it. All the following records after that looks fine and normal.

I have tried several times now and have noticed it is not always the same record that is being effected. It is always around the record number 4705982.

Does anyone know of any limitations or anything that could help me here. I have had one of my developers look at the source data and they can not find anything wrong with it.

Thanks

 

[mrdenny]

How are you exporting the data?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[grayt26]

Just SISS, taking the data from a view. We have checked the view and all seems ok with it. Also we have run queries on the data it looks at but we can not see anything wrong with that either.

 

[mrdenny]

There shouldn't be any limits in SSIS when it comes to exporting data. Try using BCP and see if it works any better.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com