• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Copy table

Hi,

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

Thanks
0
samprg
Asked:
samprg
  • 3
2 Solutions
 
Kobe_LenjouCommented:
Is the 'copy table' component not serving your needs?
0
 
Alpesh PatelAssistant 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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now