Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY
 asked on

Need a sample SSIS package

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?
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
8080_Diver

8/22/2022 - Mon
8080_Diver

Is this a 1 time thing or is this to happen on a regular basis?
VIVEKANANDHAN_PERIASAMY

ASKER
It's one time Task
8080_Diver

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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
VIVEKANANDHAN_PERIASAMY

ASKER
So we need to create 15 views right?
VIVEKANANDHAN_PERIASAMY

ASKER
I've requested that this question be deleted for the following reason:

Didn't get the answer so closing the ticket
ASKER CERTIFIED SOLUTION
8080_Diver

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question