Post reply

Foxpro Memo

  • June 16, 2003 at 8:26 am

    #106248

    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

    #461742

    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

    #461823

    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