Re: Sybase to SQL
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Jul 2005 08:44:00 +0100
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@xxxxxxxxx> wrote in message
news:uAHQ6wRhFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> 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.
>
>
.
- References:
- Sybase to SQL
- From: kid_on_the_Block
- Sybase to SQL
- Prev by Date: Microsoft DTS help
- Next by Date: Re: Automatically create table name
- Previous by thread: Sybase to SQL
- Next by thread: Microsoft DTS help
- Index(es):
Relevant Pages
|
