Unanswered: Problems migrating Sybase data to SQL server 2000
I'm having problems migrating data from a Sybase 11.9.2 server to an MS SQL Server 2000 database. I'm using DTS and setting up an ODBC connection to the Sybase database which works okay as I can use query builder to build up a query. However, even if I try just a simple select statement from Sybase to select a few rows and try transferring that into an existing table in a SQL Server database the DTS package just sits there and doesn't do anything - it says it's running but nothing happens even if I leave it for hours and hours. Can anyone think what could be causing this?