June 16, 2003 at 8:26 am
When i try to pull data from a Foxpro Memo field the data shows in the Test Run of the Transformation (from within the script) but when i execute the package the data does not import into SQL Server. Is there some manipulation that is required before the transformation needs to be done.
Thanks.
June 17, 2003 at 7:45 am
Hi,
Yes it's a problem with memo fields.
You can change the field to nvarchar or transform to nvarchar when you get the filed into SQL.
JFB
June 17, 2003 at 2:54 pm
Here's what I did.
I pulled up the memo field in the select statement using the left function. It worked. for example:
'SELECT Left(abc, 99999) as ABC, Key
FROM tblABC'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply