SSIS error iconversion checking

• jscott420

  SSC Rookie

  Points: 27

  More actions

  November 15, 2015 at 3:21 pm

  #313132

  I am not a DBA by nature. So if it something obvious please just keep that in mind.

  We have an application we have been running for 22 years and it is based on Pervasive SQL. Currently it is version 12. We are moving to a new product that is based on SQL Server. I need to move the data from Pervasive to SQL server when we go live to use our prior data in an archive interface that I am building that will be served up via a internal web application. Keeping the legacy application up and running is not an option, it will only run on 32 bit systems.

  This is a non-production server I am testing this on so I can blow it up as much as need be but I have been trying to squeeze this info into SQL for a while.

  Server 2012r2

  SQL 2014 (I can put any version on there that is needed)

  Pervasive SQL v12

  I have a 32 bit DSN on the server pointing to the Pervasive data. When I try to run SSIS with a ADO.NET source and SQL Native client destination (whether the version be 10 or 11) I get the following error pasted below. I was stuck on it erroring out on mapping column attributes "column_size" and "decimal_digits". I solved that by editing the ProvidersDescriptor.xml. I have verified all the files the wizard says it cannot fins are in fact there. I have googled and to no avail. Ideas would be appreciated. I need to have this up and running and a final import game plan mapped out in the next couple of weeks.

  

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  November 15, 2015 at 4:15 pm

  #1839863

  Am assuming you tried this.

  I didn't notice whether folks mentioned it, but I would *always* aim to use an OLE DB driver over an ADO.net driver.

  This guy seemed to make it work also, but had some issues.

  Steve.