Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Insert and Update in SSIS

Avatar of rajvja
rajvjaFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerWindows XP
4 Comments1 Solution387 ViewsLast Modified:
Hi,

    I have a requirement that I need to generate a csv file from the data.
I need to get data from two tables from the same source. I can't use join coz there will be a very complex join and I am afraid it won't get the expected results.

Ok, first I need to insert into a temp table and I want to do Update(s) on this temp table from multiple tables and joins. Then from the temp table, csv file is generated.

What is the best way to design this?

What I am doing is, DFT-> 2 OLEDB Sources -> UNION ALL -> OLEDB Destination
CONTROL FLOW -> Exec SQL Task -> First Update
CONTROL FLOW -> Exec SQL Task -> Second Update
CONTROL FLOW -> Exec SQL Task -> Third Update
CONTROL FLOW -> Exec SQL Task -> Fourth Update

Again DFT - > generate CSV

Is there any other best way to do?

thanks
ASKER CERTIFIED SOLUTION
Avatar of PedroCGD
PedroCGDFlag of Portugal image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers