LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » Integration Services (SSIS) and DTS » Export Flat Text file contains special character instead of Carriage Return

Export Flat Text file contains special character instead of Carriage Return

Options

Previous Topic · Next Topic

WayneL15

Posted: Wednesday, March 25, 2009 10:46:13 AM

Rank: Newbie

Joined: 3/25/2009
Posts: 5
Points: 15
Where do you live?: New York

Good Day,

I'm recreating a data export package, now in SQL 2005 SSIS, to pull data from a database view to export it into a flat text file. The data columns need to be tab delimited with a carriage return to delimit the rows.

When viewing the outputed text files in notepad the {CR}s are replaced by some special character that is similar to a square.
Since the flat file is intended to be imported by another system I am concerned that this could cause an issue for us.

Example rows when viewing file created by legacy DTS package on SQL2000 server.
"1", "Helllo", "Test", "John", "Williams"
"2", "Helllo", "Test", "Joe", "Smith"
"3", "Bye", "Test", "Roger", "Waters"

Vs. example created by SSIS on SQL2005:
"1", "Helllo", "Test", "John", "Williams"[]"2", "Helllo", "Test", "Joe", "Smith"[]"3", "Bye", "Test", "Roger", "Waters"[]
[] represent square type symbol.

Any insight you may have is appreciated.

Thank you for your consideration in advance.

Scott Whigham

Posted: Monday, March 30, 2009 10:56:09 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: Dallas, TX

Clearly that line break character is not getting inserted correctly. How are you doing the export - what task? It's kinda hard, Wayne, without seeing more info to offer too much. If you can supply more details (screenshots?), I might be able to help quicker.

WayneL15

Posted: Monday, March 30, 2009 11:50:40 AM

Rank: Newbie

Joined: 3/25/2009
Posts: 5
Points: 15
Where do you live?: New York

I'm using a SSIS Dataflow task from a SQL2005 DB view to a to a Flat file destination.

How do you post an attachment? I am not sure if I have rights to do so.

WayneL15

Posted: Monday, March 30, 2009 2:59:51 PM

Rank: Newbie

Joined: 3/25/2009
Posts: 5
Points: 15
Where do you live?: New York

Issue resolved.

Changed the Unicode settings. Also updated the values for the last column of data. Seems to have done the trick.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.