I'm trying to import data from an Access database to a SQL Server database. I
am using SQL Server 2005 Integration Services. The tables already exist in
the SQL server database. I am having trouble with converting the memo fields
(unicode text) to the varchar fields in SQL Server. How can I use a data
conversion object to do the conversion?

Your help will be appreciated.


--
Jerry J

You can add a Data Conversion transform and change the datatype from unicode
string to ansi string. But that doesn't solve your current problem because
the Access memo is a Unicode stream, not a string. I couldn't find a
conversion that worked, so I gave up and made the sql server datatype either
nvarchar(max), which doesn't need any conversion, or varchar(max) which
needs to be converted from Unicode stream to ansi stream.

I found the change from DTS implicit datatype conversions to SSIS requiring
explicit conversions to be a step backwards.

Paul Shapiro

"Jerry J" <JerryJ (AT) discussions (DOT) microsoft.com> wrote

I've had some success with converting Access memo fields to SQL Server Text
type fields.

"Jerry J" wrote: