Napiweaser
New Member
Hello! We were running Progress 8.3 on AIX 4.3 and pulling about 26 tables into SQL 7.0 every night using an OI broker and Datadirect Sequelink. We had one complex DTS package on the SQL server that would kick off nightly to pull the data over and populate "similar" tables on SQL that we would hit with an Access front end for ad-hoc reporting. It worked out to be about 1/2 GB a night.
We've upgraded Progress to 9.1E and AIX 5.3. The SQL DTS package won't work because the new SQL92 driver & Datadirect (Connect for ODBC) does not treat arrays like they used to.
Am I left to redesign the entire DTS package somehow? I've looked at Progress solution ID 19061 and haven't a clue how to tie that into the DTS package we developed years ago. We have an extensive number of arrays in our tables (not by my design!).
Any assistance would be greatly appreciated!!
~Dave
We've upgraded Progress to 9.1E and AIX 5.3. The SQL DTS package won't work because the new SQL92 driver & Datadirect (Connect for ODBC) does not treat arrays like they used to.
Am I left to redesign the entire DTS package somehow? I've looked at Progress solution ID 19061 and haven't a clue how to tie that into the DTS package we developed years ago. We have an extensive number of arrays in our tables (not by my design!).
Any assistance would be greatly appreciated!!
~Dave