Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CSV file problem

Status
Not open for further replies.
Cpreston

Cpreston

MIS
Mar 4, 2015
969
0
16
GB
Hi

I have created a flat file destinations from our SQL view to a csv file. It exports ok except the format seems to be getting corrupt on export.

The field in questions is a long text filed which as other characters in other than comma's. For example a colon :)). I think this is then creating carriage returns.

Does anyone know how to get it so it ignores these and then create the text file correctly.

Thanks
 
Status
Not open for further replies.

Similar threads

TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
81
mark williams
mark williams
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
67
fredericofonseca
fredericofonseca
Vronsky
  • Locked
  • Question
SSIS importing flat file (CSV)
Replies
0
Views
66
Vronsky
Vronsky
lavadan
  • Locked
  • Question
CSV file escape phone number format
Replies
0
Views
66
lavadan
lavadan
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
60
arunaramana
arunaramana

Part and Inventory Search

Sponsor

Back
Top