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.

Not using the wizard. The wizard expects you to either transfer the table
in full which in turn allows you to import/export many tables or it expects
you to enter a query which in turn means you move only one table.

You may be best handling this on the Source. Maybe you could write views of
the tables that only selected the top 10 rows by your criteria.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"kid_on_the_Block" <mindzone (AT) gmail (DOT) com> wrote