Hi All,
I am using Merant ODBC driver for connecting to Progress8 DB,and importing data into SQL Server using DTS.
I have to change the database dynamically when there is change in DB in Progress and connect to new DB and import the data.
I have used Dynamic Property in DTS to get the current database and change the DSN initial catalog for Merant ODBC driver connection.(Source database)
But DSN does'nt change and tries to import from previous connection only.
I have searched the many forums and unable to find the solution for this.
Is this an issue with Merant or SQL Server DTS?
Please help to solve this, our release depends on this and getting delayed...
I am using Merant ODBC driver for connecting to Progress8 DB,and importing data into SQL Server using DTS.
I have to change the database dynamically when there is change in DB in Progress and connect to new DB and import the data.
I have used Dynamic Property in DTS to get the current database and change the DSN initial catalog for Merant ODBC driver connection.(Source database)
But DSN does'nt change and tries to import from previous connection only.
I have searched the many forums and unable to find the solution for this.
Is this an issue with Merant or SQL Server DTS?
Please help to solve this, our release depends on this and getting delayed...