DTS

How do we configure DTS package to transfer more than 1 table data transfer from a Source to Destination Server?
I have about 100 odd tables in Source & need to do data transfer for all within 1 go. Is this possible?If you are on SQL Server 2000 and the source and destination
are both SQL Server(7 or above), you can use the Copy SQL
Server Objects task.
-Sue
On Wed, 5 Nov 2003 13:11:07 -0800, "Prasanna"
<anonymous@.discussions.microsoft.com> wrote:
>How do we configure DTS package to transfer more than 1 table data transfer from a Source to Destination Server?
>I have about 100 odd tables in Source & need to do data transfer for all within 1 go. Is this possible?|||The simplest way is USe the DTS wizard.
or
In , SQLEM,go to "Tools" and then CLick "DTS" and then Use
the Export/Import. (This will also get you the DTS Wizard)
Very simple and user friendly wizard.You can easily do it.
SQLVarad(MCDBA-1999,MCSE-1999)
>--Original Message--
>If you are on SQL Server 2000 and the source and
destination
>are both SQL Server(7 or above), you can use the Copy SQL
>Server Objects task.
>-Sue
>On Wed, 5 Nov 2003 13:11:07 -0800, "Prasanna"
><anonymous@.discussions.microsoft.com> wrote:
>>How do we configure DTS package to transfer more than 1
table data transfer from a Source to Destination Server?
>>I have about 100 odd tables in Source & need to do data
transfer for all within 1 go. Is this possible?
>.
>