Sybase to SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

I am trying to import some 490 tables from Sybase to SQL Server. I just want
the first 10 records of each table to be imported , can we do that using DTS
wizard....
or is there some other method plz help


Thanks.


.

Relevant Pages

  • Through Put AS vs. SQL Server
    ... I have notice that the current through put from SQL Server to Analysis ... Services is aprox from 20000 to 30000 rows per second if both services are on ... I have also notice that using ODBC (Sybase IQ) I am only able to transfer ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)
  • Re: Migrating SQLServer DBs to Sybase
    ... Server-generated scripts to create the structure in Sybase, and SQL Server ... AseConnection objCon = new AseConnection; ... objCon.ConnectionString = strConnectionString; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Scheduling DTS job
    ... If you try to transfer the same rowsfrom SQL Server to SQL Server ... > How do i see if there is any difference in the driver ... >>> The SQL server agent is running as Local System Account. ... >>> Nothing has been changed in sybase box. ...
    (microsoft.public.sqlserver.dts)
  • RE: Numeric Overflow of Column of datatype Money
    ... Sybase driver is failing on the column, long before it reaches SQL Server. ... That I have serveral column with datatype money that didnt have the ...
    (microsoft.public.sqlserver.dts)
  • RE: Connecting to Sybase
    ... Have you tried pushing the data directly into AS using SSIS, ... This paper describes push mode processing in more detail: ... issue with pulling the data from Sybase on a daily basis and putting it into ... a Sql server table then having ssas get the data from there. ...
    (microsoft.public.sqlserver.olap)