Hi,

Is there any way I can copy multiple tables using any controls in SSIS ?

Thanks.

can you explain what you want to do?


"Kris" <Kris@discussions.microsoft.com> wrote in message
news:338E2BC8-5B4F-483C-B544-98EDB9D7837E@microsoft.com...
> Hi,
>
> Is there any way I can copy multiple tables using any controls in SSIS ?
>
> Thanks.

Sure, Thanks Jeje.

I would like to copy 30 tables from Source system to WH every day. At
present I have used Data Flow talk for each table to copy. Is ther any Way, I
can copy all the tables using one Task ? Like in SQL 2000 I have used Copy
SQL Server Object task ..any help pls.

Thanks.



"Jeje" wrote:

> can you explain what you want to do?
>
>
> "Kris" <Kris@discussions.microsoft.com> wrote in message
> news:338E2BC8-5B4F-483C-B544-98EDB9D7837E@microsoft.com...
> > Hi,
> >
> > Is there any way I can copy multiple tables using any controls in SSIS ?
> >
> > Thanks.
>

You can put the SELECT....INTO syntax for all your tables into sql script
and run that as a task. You can put object verification functionality and
action before this.

This could be put into a single task.

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"Kris" <Kris@discussions.microsoft.com> wrote in message
news:338E2BC8-5B4F-483C-B544-98EDB9D7837E@microsoft.com...
> Hi,
>
> Is there any way I can copy multiple tables using any controls in SSIS ?
>
> Thanks.

1)Set up the 2 connections
2)Create a Preparation SQL Task - (include all your CREATE TABLE processes)
3)Set up your Data Flow Task

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com




"Kris" <Kris@discussions.microsoft.com> wrote in message
news:338E2BC8-5B4F-483C-B544-98EDB9D7837E@microsoft.com...
> Hi,
>
> Is there any way I can copy multiple tables using any controls in SSIS ?
>
> Thanks.