I have not had luck much luck pushing or pulling data using an MSSQL DTS
package.  Apparently you can script automatically to just about any data
repository, even text files but I think you should call on an MSSQL guru.

I had the most success with EA/MSSQL. Two separate automated systems:

1. via OpenROAD. simple select / insert loop to keep an ingres DB
syncronised with an MSSQL db. Also did the same for ingres/oracle
syncronisation between Melbourne and Sydney

2. via copydb bulk unload/reload. It needed some massaging of the script.
Watch out to factor by 100.

Paul

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com]On Behalf Of David
Greenberg
Sent: Tuesday, 25 November 2008 8:56 PM
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] How do I Sql Server float8 to Ingres money type

Hi
I want to copy data from Sql Server 2000 to Ingres 2.0 by way of a DTS.

Does anyone know the correct sql server syntax to copy an sql server
float8 field to an Ingres money field ?

David Greenberg
_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres