[CA IDMS ODBC Driver]Restricted data type attribute violation

• Manojn

  Valued Member

  Points: 62

  More actions

  March 21, 2024 at 9:06 pm

  #4399730

  I moving data from mainframe to SQL server.

  Error:

  Unable to copy contents of source table to destination (Insert/SelectFull) Unable to get record from table (table_3). >>> STAT:2 ERR:-2147467259 SQLSTATE:S1000 Microsoft OLE DB provider for ODBC Drivers : [CA IDMS ODBC Driver]Restricted data type attribute violation

  using CA IDMS ODBC driver to read on mainframe and using CONNX etl tool to sync data to SQL server native client.

  • all columns are moving except for one column. which packed fields on mainframe.

  Need help in pointing me to the right direction. Where can i start with ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736173

  More actions

  March 21, 2024 at 10:03 pm

  #4399745

  What are the data types of the source and destination for this column? I'm guessing this is a numeric field on the mainframe?

   

  Does this help? https://www.mssqltips.com/sqlservertip/3459/importing-mainframe-data-including-packed-numbers-with-sql-server-integration-services/