Hi to all members of this useful Forum.
I am new of PROGRESSTALK.COM and i work in an italian company that uses PROGRESS Software from 2005.
This company has a PROGRESS DB stored in a UNIX SERVER with AIX operating system.
Version DB PROGRESS OpenEdge Release 10.2B05
This company has also a Window Server with SSAS 2008 R2 , to work with DataWare House.
i DECIDED to reading tables of the PROGRESS DB using a LINKED SERVER of SQL SERVER 2008 R2.
I need to do this , to fill the tables of SQL SERVER DB for ANALISYS Services.
I use Microsoft SSIS 2008 R2 to import data from my ERP to SQL SERVER DB.
I installed :
ODBC MERANT Progress on the SQL SERVER
I created successfully also my DSN and LINKED SERVER on the same server SQL SERVER.
Connection test and tests reading were okay.
PROBLEM:
All it is fine , if I read records from little tables o medium large tables (From 50 to maximum 500.000 records).
BUT WHEN I TRY TO READ A LARGE SIZE TABLE (in my real situation a table of 1.300.000 records) , VISUAL STUDIO 2008 SSIS but also DATABASE ENGINE 2008 ,
read only 556.000 about records !!!!!!!!!!!
It means NO ALL RECORDS but only a part of that table...
why ????????????????
I checked also :
Log file of PROGRESS DB , no warning no errors...
SQL SERVER and VISUAL STUDIO 2008 log errors, but they tell me "QUERY SUCCESSFULLY" ...no warning no errors, neither query timeout...
I checked my DSN to connect DB PROGRESS, i put READ UNCOMMITTED and i set
query timeout = 0....is it all correct ??????
Now i am a bit confused and i am not able to solve my problem.
Regards to everyone, and forst of all HAPPY CHRISTMAS to You and your families.
I hope in a response, to understand and to learn every day, new things..
Mauro Marchi.
I am new of PROGRESSTALK.COM and i work in an italian company that uses PROGRESS Software from 2005.
This company has a PROGRESS DB stored in a UNIX SERVER with AIX operating system.
Version DB PROGRESS OpenEdge Release 10.2B05
This company has also a Window Server with SSAS 2008 R2 , to work with DataWare House.
i DECIDED to reading tables of the PROGRESS DB using a LINKED SERVER of SQL SERVER 2008 R2.
I need to do this , to fill the tables of SQL SERVER DB for ANALISYS Services.
I use Microsoft SSIS 2008 R2 to import data from my ERP to SQL SERVER DB.
I installed :
ODBC MERANT Progress on the SQL SERVER
I created successfully also my DSN and LINKED SERVER on the same server SQL SERVER.
Connection test and tests reading were okay.
PROBLEM:
All it is fine , if I read records from little tables o medium large tables (From 50 to maximum 500.000 records).
BUT WHEN I TRY TO READ A LARGE SIZE TABLE (in my real situation a table of 1.300.000 records) , VISUAL STUDIO 2008 SSIS but also DATABASE ENGINE 2008 ,
read only 556.000 about records !!!!!!!!!!!
It means NO ALL RECORDS but only a part of that table...
why ????????????????
I checked also :
Log file of PROGRESS DB , no warning no errors...
SQL SERVER and VISUAL STUDIO 2008 log errors, but they tell me "QUERY SUCCESSFULLY" ...no warning no errors, neither query timeout...
I checked my DSN to connect DB PROGRESS, i put READ UNCOMMITTED and i set
query timeout = 0....is it all correct ??????
Now i am a bit confused and i am not able to solve my problem.
Regards to everyone, and forst of all HAPPY CHRISTMAS to You and your families.
I hope in a response, to understand and to learn every day, new things..
Mauro Marchi.