CODEWITHSUNDEEP
ssis
ZAJ
ZAJ

Reputation: 835

Trasnfer multiple table from one databsse to another database using SSIS

Can somebody please help me to transfer around 15 tables from one database to another database. At present I can do this one by one using Data Flow task, but then I need to do this task 15 times which is very time consuming.

Upvotes: 1

Views: 5117

Answers (3)

9Squirrels
9Squirrels

Reputation: 43

For anyone else looking for the answer to this, here's an alternative method: https://www.youtube.com/watch?v=YXeEZsGmJrI

Short version: use the "Transfer SQL Server Objects Task" in SSIS.

Upvotes: 0

user10929229
user10929229

Reputation: 11

you can use SSIS package, select Transfer SQL server objects from SSIS toolbox , in Object specify the source and destination servers and database. for copyAllObjects make it false . ObjectToCopy select CopyAllTables true or make it false and pick from the list the table you want to copy.

Upvotes: 1

makciook
makciook

Reputation: 1555

Why don't you just use a task? Maybe tasks->export is what you're looking for. Otherwise you'll need to create separate blocks for each table or:

  1. Create a variable of type object
  2. Script Task: Add to your list all table names.
  3. Iterate over this object variable with For each loop container
  4. Inside the loop create a source from a variable. In this variable specify the connection dynamically depending on the current loop value.

Upvotes: 1

Related Questions