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?
 
Reza RadConnect With a Mentor Consultant, TrainerCommented:
glad to hear,
you solved it.
Regards,
0
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
k1ng87Author Commented:
did that and you're right...it seems to be franklin but a simple "select *" runs fine from the source table....
0
 
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:
thanks for points
I appreciate it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.