Importing Sybase database to SQL Server 7.0

[rohitpabby]

Hi there!

I want to import table/data from the Sybase database to SQL Server 7.0 using DTS but I can not find how to link to the Sybase database in 'Choose a Data Source dialog box' of DTS wizard. Can some body help me how I can do this?

Thanks.

Warm Regards,
Rohit Pabby

 

[fluteplr]

You go have odbc or ole/db drivers for your Sybase database. If so set them up and use the appropriate import option. DTS will import from most if not all odbc or ole/db data sources.

 

[rohitpabby]

Can you please tell me from where to get it?

 

[foxdev]

Rohit, you get them by installing the Sybase client tools from the Sybase CD. --------------
Low Cost Prints:

http://www.lowcostprints.com