Need a sample SSIS package

VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY used Ask the Experts™
on
My problem:

I have 10 database which holds 15 tables,
One table has application Name and will be linked across 15 tables through Foreign Key or with application name itself.
There are multiple applications present in one database.
Now I want copy only few application's along with all it's relevant data from each of the database and like to club it all together in one database.

How to do it?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Is this a 1 time thing or is this to happen on a regular basis?
It's one time Task
Can you create one or more views in the original database that select the desired data?

If so, you can use the Import/Export wizard to import the data from the views into your target database.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

So we need to create 15 views right?
I've requested that this question be deleted for the following reason:

Didn't get the answer so closing the ticket
Actually, I think I did provide an answer.  If the author will create a view on any one of the tables in question and thenuse the Import/Export wizard, the author can save the results to an SSIS package and then use that for a templte.  On the other hand, if the author creates a view for each table (and, yes, that does mean 15 views for 15 tables . . . but that's not so bloody many, really, is it?), then they can all be combined into one, single Import/Export Wizard process.

It's a one-time thing, so I would just use the Import/Export wizard and do it. :-/ ;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial