Sybase And MSSQL

Hi Everyone -





I have a master database (sybase) that is in place as a company


legacy server -





I am setting up a web server to act as an intranet and data entry


terminal system.





I want to ultimately remove sybase from the picture, but


for now, i need to grab information from the sybase server


and populate the MSSQL database with the values from the


sybase database.





So my question is this -





Is there a way to setup a "auto polling" or synching between the MSSQL


and the sybase system.





If there isn't then i will need to do a DTS job to grab the values from


the sybase ODBC connection, and populate my database that way -


but there must be another way to accomplish this task.





thanks





take care


tony