Importing Multiple Tables

[wallaceoc80]

With DTS is it possible to import multiple tables in one go?

If so how?

Regards,

Wallace

 

[dbomrrsm]

depends what you mean by "one go" if you mean in one step I dont believe you can - you can bring data from multiple tables into one table in one DTS step but not multiple tables to multiple tables - so far as I know.

This is one reason why DTS is useful - you cna have multiple step that bring in data from one table to another so in effect you are importing multiple tables in one go when you run the DTS package.

DBomrrsm

 

[wallaceoc80]

How do you create these multiple steps?

I have looked but I can't find how!

 

[dbomrrsm]

create one connection and one destination then do a data transform between them - then repeat process as many times as you like.

Look in Books Online BOL under data transformation services DTS packages.

Good luck

DBomrrsm