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 |
|
sachingovekar
Posting Yak Master
101 Posts |
 Posted - 2014-08-01 : 08:10:44
|
| Hi,I am trying to export some data from sql server into txt file.when i preview the data or see the exported file, I can see a line break after 1st column.this is because I can see a small box in first column values.Please helpRegards,Sachin |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2014-08-01 : 11:23:52
|
| You may have a Carriage Return / Line Feed in your data.Check out the data to see if you have Carriage Return / Line Feed.If you do then use a Derived Column task in you Data Flow.In the Derived Column transformation editor, use Replace Function to remove the Carriage Return / Line Feed. Hope this helps |
 |
|
|
|
|
|
a small box in data creates line break