DTS Import Fails - Punctuation in Varchar Column
Posted on 2005-04-14
I'm stumped by what seems to me to be a non-issue, but which has been giving me fits today. I'm trying to import a table from an ODBC data source (in this case, a MUMPS database). One of the columns, a text column, contains the value "40+" (no quotes in the data) for multiple rows. I am trying to import this column into a varchar(255) column, but the presence of the "+" sign throws multiple errors and the DTS package fails. I've tried using an ActiveX transform as well as a Copy Column, but neither works. Can someone suggest an alternative that will allow me to successfully pull the data?