April 25, 2011 at 9:44 pm
I am trying to export a table to flat file using Pipe Delimited(Doesnt matter if its other delimited also).
There is a column which has datatype varchar(512) when exported to flat file it comes into next line instead of single row such as
33439476|Box|W|BI|GSDN|C|0|4347|Watch Video to learn more.<ul class=bullet_
primary_sm><li>Works on High Definition or Standard Definition TVs</li><li>Watch HD and standard defin
ition programming</li><li>^M
Access to extensive Video on Demand library with HD and SD Content</li><li>Interactive Media Guide</li
>||N|N|N|
The above matter belongs to a single column but the text has come into next line.
There is an embedded “END OF LINE” comes in as part of this record which make is look like 2 rows for loading instead of one line.
Please help me how to do this i have tried to replace the empty space and tab space but nothing has worked ou tplease help how to get in single row....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
April 26, 2011 at 7:01 am
Sri8143 (4/25/2011)
I am trying to export a table to flat file using Pipe Delimited(Doesnt matter if its other delimited also).There is a column which has datatype varchar(512) when exported to flat file it comes into next line instead of single row such as
33439476|Box|W|BI|GSDN|C|0|4347|Watch Video to learn more.<ul class=bullet_
primary_sm><li>Works on High Definition or Standard Definition TVs</li><li>Watch HD and standard defin
ition programming</li><li>^M
Access to extensive Video on Demand library with HD and SD Content</li><li>Interactive Media Guide</li
>||N|N|N|
The above matter belongs to a single column but the text has come into next line.
There is an embedded “END OF LINE” comes in as part of this record which make is look like 2 rows for loading instead of one line.
Please help me how to do this i have tried to replace the empty space and tab space but nothing has worked ou tplease help how to get in single row....
Is this a one time job? I'm asking because I had a similar problem and found it easier to do it manually from SSMS. Basically I Selected All columns from the table, then selected all the data, copied and pasted into excel, then saved the file in a csv format (in my case).
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
April 26, 2011 at 8:42 am
Brian...I need to create a package and schedule it as a job so it is not a one time process also i have 100 thousand rows ...any other suggestions would be helpful on how to fix it....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply