Problem using ODBC driver from MS SQL DTS package

Hi there,

I am having problems using the latest version of the driver (Both the
stable and the beta version) from a DTS package on a Win2K server box
with SQL server 2000.

I am trying to pull data from a postgresql 7.2.1 database, and the
problem is that when I try an specify a transformation with the ODBC
connection being the destination, the mmc.exe program starts leaking
memory at about a MB/sec and the application gui freezes.

I am not sure if this is just a bug in the Microsoft program, or if it
is related to using the ODBC driver.

Has anyone else experienced this?


Here is the query from the MS SQL database I am trying to insert into a
postgresql database via DTS

select 'host401' as key, max([identity]) as lastidentity from alldata

and the postgresql query I am trying to pull into a MSSQL database

select * from alldata where "identity" > (select max("identity") from
replicationinfo where key='host401')

I have successfully used this from an xp system with sqlserver 2000 (But
without servicepack3), but have had no luck from a windows2000 system
with servicepack3.

Again, the leak occurs when I click on the transformation tab. So this
would be parsing the query via the ODBC driver I imagine, and trying to
get back tha names/types of the result set that the query would return.


--
David Stanaway
DialMex LLC
NOC Engineer
200 S. 10th Street Suite 1209
McAllen, TX 78501

(956) 994-0014 x111 office
(956) 239-0840 mobile
(956) 682-5821 fax
david@dialmex.net