Hi, you can create an SQL task that trims spaces from your varchar columns. The code below also pulls out any commas from the varchar field - this is...
I had the same problem importing an Excel file. I got around it using the sqldts.com column you mentioned along with an ActiveX script that saves the file as...