Load Ingest Data
Results 1 to 2 of 2

Thread: Data type error for pulling Data from file pointer keys in VMS

  1. #1
    raghuj is offline Junior Member
    Join Date
    Jan 2010
    Posts
    1
    Rep Power
    0

    Data type error for pulling Data from file pointer keys in VMS

    I am encountering an error with the data type, when trying to pull data from VMS. The data structure in VMS is hierarchial and keys are file pointers. Those key columns start with _O_... , OLEDB driver is not able to parse it correctly.


    Msg 7354, Level 16, State 1, Line 1
    The OLE DB provider "AttunityConnect" for linked server "DRILLME_MA_BR" supplied invalid metadata for column "_O_MA_SOHCOMCSET". The data type is not supported.

  2. #2
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14
    Hi

    Pls use the following OLEDB property to suppress chapters.

    From the AIS documentation:
    "Suppress chapters: Select this to suppress chapters in OLEDB. In this case, Chapters are exposed as regular columns. Use this property to prevent an SQL server error for a bad datatype."
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •