Copy table

Hi,

I need to copy table A to A1,A2 and A3 by SSIS BID

Thanks
samprgAsked:
Who is Participating?
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Yes there is a task named "Transfer SQL Server objects task".
Please see screen shot for more details. Transfer SQL Server objects task
0
 
Kobe_LenjouConnect With a Mentor Commented:
Is the 'copy table' component not serving your needs?
0
 
samprgAuthor Commented:

I want to make copy to 3 tables at same time, so I used 'Multicast' but I get error
Wher is 'copy table'?

thank you
0
 
samprgAuthor Commented:
Hi

Is "Transfer SQL Server objects task" transfer the index too ?
I need to copy the tables with index "clustred"

Thanks
0
 
samprgAuthor Commented:
Thank yuo so much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.