Can't get Carriage Return to work on lage column

Question

Creat

ed a SSIS Package that grabs data from a Sql 2008 r2 database table and puts the data in a .dat flat file.

everything works just like it is suppose to excpt it places the data in th flat file as one big continouse string. The last column is suppose to do a carriage return and start the next row of data on the next row of the flat file.

What am I doing wrong?

Thank you

Answer 1

Answer 2

Answer 3

Those are all my screens for the package.

Please help.

Thank you

Answer 4

How did you add the CR LF column? Are those special characters actually in there?

---

MCTS, MCITP - Please mark posts as answered where appropriate.
Answer #1: Have you tried turning it off and on again?
Answer #2: It depends...

Answer 5

why don't you use "Ragged Right" instead of "Fixed Width"?

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 6

I don't know if those characters are there or not. How can I get those characters in there? And how can I test to see if they are there or not?

thank you

Answer 7

Hi,

Yep, the easiest solution is to use "ragged right" instead of "Fixed width"

A more difficult solution would be to keep your CRLF column, and fill it up from a "dummy" T-SQL function dbo.CRLF()

This "dummy" function may be created as

USE YourDB
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION dbo.fnCRLF() RETURNS CHAR(2)
AS
BEGIN
  RETURN CHAR(13)+CHAR(10)
END

GO

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu