CSV import - character before CRLF

[SQLScholar]

Hey all,

A little help here.

I am taking a file which is created by lots of batch scripts (would rather not have to alter them!) and wanting a SSIS scheduled task to load it into SQL.

Well normally this would be easy - however i have an issue. There seems to be a character (in notepad - it looks like a space) which causes SQL to error. SSIS then cannot find the text qualifier on the final column. If i remove this character - it then uploads fine.

If i open this file in excel - it opens fine. If i save it then from excel, it uploads fine.

How can i clean this file automatically with SQL before upload? Is there any way i can find what this character is.

Many thanks

Dan


----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[MDXer]

if you know there character code then you can replace it using a derived column task.

 

[SQLScholar]

Sorry - i should have posted. Fixed it - just did a script that removed the last char. works fine now. Sorry.

DAn

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------