V6.1 - Importing Progress data into SQL Server

Hi Robert,

If your DTS package works manually and not via a schedule it is
probably more likely to be the SQL agent is set to run in the context of the
LocalSystem Account, try running this as a domain user / administrator
account.



Regards,

Stephen Edginton



_____

From: Robert MacDonald [mailto:rmacdonald@...]
Sent: Tuesday, August 01, 2006 4:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] v6.1 - Importing Progress data into SQL Server



Hi All,

We are trying to import data from Vantage 6.1 (Progress) into MS SQL
Server 2000 using a DTS package.

The package runs fine when run manually, but will not run when scheduled
or called from a procedure.

We believe it is the Progress ODBC driver (Merant 3.60 32-bit Progress
SQL92 v9.1D) which is not local but on the Vantage server and accessed
via a mapped drive, which is causing the failure. We think it has
something to do with lack of support for mapped drives in SQL Server. A
call to Vantage support informed us that is the only way the ODBC driver
for vantage can be installed.

Has anyone been successful in importing data into MS SQL Server in an
automated fashion?

If so, how did you do it?

Thanks,

Robert MacDonald

Information Technology Manager

Ground Effects Ltd.

[Non-text portions of this message have been removed]




--

Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 31/07/2006



--

Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 31/07/2006



[Non-text portions of this message have been removed]
Hi All,

We are trying to import data from Vantage 6.1 (Progress) into MS SQL
Server 2000 using a DTS package.

The package runs fine when run manually, but will not run when scheduled
or called from a procedure.

We believe it is the Progress ODBC driver (Merant 3.60 32-bit Progress
SQL92 v9.1D) which is not local but on the Vantage server and accessed
via a mapped drive, which is causing the failure. We think it has
something to do with lack of support for mapped drives in SQL Server. A
call to Vantage support informed us that is the only way the ODBC driver
for vantage can be installed.



Has anyone been successful in importing data into MS SQL Server in an
automated fashion?

If so, how did you do it?



Thanks,



Robert MacDonald

Information Technology Manager

Ground Effects Ltd.





[Non-text portions of this message have been removed]
If it works manually it seems strange that the ODBC configuration is failing
when the process is automated.



Do you have a linked server connection configured in SQL 2000 does SQL allow
you to query the tables with openquery correctly?



Regards,

Stephen Edginton

_____

From: Robert MacDonald [mailto:rmacdonald@...]
Sent: Tuesday, August 01, 2006 4:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] v6.1 - Importing Progress data into SQL Server



Hi All,

We are trying to import data from Vantage 6.1 (Progress) into MS SQL
Server 2000 using a DTS package.

The package runs fine when run manually, but will not run when scheduled
or called from a procedure.

We believe it is the Progress ODBC driver (Merant 3.60 32-bit Progress
SQL92 v9.1D) which is not local but on the Vantage server and accessed
via a mapped drive, which is causing the failure. We think it has
something to do with lack of support for mapped drives in SQL Server. A
call to Vantage support informed us that is the only way the ODBC driver
for vantage can be installed.

Has anyone been successful in importing data into MS SQL Server in an
automated fashion?

If so, how did you do it?

Thanks,

Robert MacDonald

Information Technology Manager

Ground Effects Ltd.

[Non-text portions of this message have been removed]




--

Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 31/07/2006



--

Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 31/07/2006



[Non-text portions of this message have been removed]