[ezRETS-users] ezRETS and Microsoft DTS on SQL Server 2000

[Spencer Tabbert]

I am in the process of setting up some data feeds from several MLS's.
Currently I am using SQL Server 2000 and DTS to process our MLS data feeds.
Evaluating all of the RETS clients out there I am finding ezRETS seems to be
most appropriate to what I need.  I was able to write a pretty simple DTS
package after creating the DSN for each MLS where I was able to then
establish that as an ODBC Source in the DTS package and then use a Transform
Data Task to write the data right to a SQL Server database table.  This
proved a bit tricky as I hit the known issue of decimals crashing the
Enterprise Manager but after configuring the driver to convert everything to
varchar this worked nicely to get the listing data.
 
The problem I am running into now is how to get the images.  I was hoping
that I might just use another dts package with a different query and write
the images as blobs to a database table and then run another script to
export them to files.  Unfortunately I am hitting this issue where
Enterprise Manager crashes on me with no warning or error again.  At this
time I don't see a way around it unfortunately.  Is there an update on this
issue or any known workarounds or suggestions on how to pull the images off
using the ezRETS client?
 
Spencer Tabbert
Voice: 262-442-3721
Fax: 262-364-2117 
stabbert at purestrategy.net
 
Pure Strategy
W276 N2744 Trillium Ln
Pewaukee, WI 53072
 <mailto:stabbert at purestrategy.net>  
 <http://www.purestrategy.net/>  
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.crt.realtors.org/pipermail/ezrets-users/attachments/20070316/24470e4e/attachment.htm