Dds,ata convertion from Progress database to SQL Server 2005 using SSIS

• Sarath Vellampalli

  SSCertifiable

  Points: 5822

  More actions

  March 15, 2012 at 1:28 pm

  #270111

  Hi All,

  I am new to Progress database and i want to migrate the data from progress database to SQL2005 by using SSIS, so how can we achive this please help me on this.

  We have tried with ODBC connection but it was not migrated full database, so i need full database migration. please help me on this.

  Regar

  Kindest Regards,

  Sarath Vellampalli

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 16, 2012 at 8:26 am

  #1460543

  Can you be more specific?

  What do you mean by "it was not migrated full database"? Does that mean that you were missing data or that you need to migrate schema?

  Did you successfully connect to the progress database using ODBC within SSIS?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question