UNION ALL ssis package running veeerrryyyy slow

I have a UNION ALL ssis package to merge two tables together...table 1 has about 600k rows and table 2 has about 400k rows...the package has been running for an hour now and is still running....shouldn't this take about 10min to run??

a simple select * from each table takes only a few minutes to run....

using sql server 2000
dts.png
LVL 1
k1ng87Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

k1ng87Author Commented:
also, the table1(accuship) takes about 3-4minutes to complete...the franklin one takes foorrreeevverrrr and is still running...
0
Reza RadConsultant, TrainerCommented:
what happen if you just read data from franklin and try again?
I mean maybe problem in hanging is in Franklin data source, did you check it alone?
0
k1ng87Author Commented:
did that and you're right...it seems to be franklin but a simple "select *" runs fine from the source table....
0
Determine the Perfect Price for Your IT Services

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

Reza RadConsultant, TrainerCommented:
maybe there is a problem in your data,
could you try it for example with a select top 4000 * from source table in Franklin or other selects which specify a portion of data ,
test it and try to find out where in the data in Franklin datasource cause the problem.
optimization tips on Franklin data source table would be helpful too, for example index and ....


0
k1ng87Author Commented:
I used a "sql command" instead of a "table view" in the source which seemed to have fixed the problem...
0
Reza RadConsultant, TrainerCommented:
glad to hear,
you solved it.
Regards,
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Reza RadConsultant, TrainerCommented:
thanks for points
I appreciate it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.