CODEWITHSUNDEEP
sqlssisexporttext-filesnewline
mgo
mgo

Reputation: 65

SSIS export view to text file with fixed spacing

I would like to export data from a view to a text file. I am using a package to do this. The package can run and gives as an output a textfile indeed. The format is based on fixed width spacing. However each record-line should end with an CRLF. In order for the next record to start on a new line.

How can this be best accomplished?

thanks for your help, best regards, Mano

Upvotes: 1

Views: 202

Answers (1)

vercelli
vercelli

Reputation: 4757

Like @Murthy said you can accomplish that with Ragged Right:

enter image description here

enter image description here

enter image description here

Upvotes: 1

Related Questions