Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harrisw48
Starting Member
34 Posts |
 Posted - 2011-09-30 : 08:30:59
|
| Im trying to import a file that has no carriage retutn line feed at the end of a row.In fact I dont think there is anything to identify end of a row.The fields do seem to be the same length but how do I import this without an end of row marker |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-30 : 11:04:14
|
| do you mean to say the file is having never ending stream of data? then whats marks start and end of row?if length is fixed you can use fixed length type flat file connection and set width using ruler in it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Text File with no carriage return or line feed