Thank you for the suggestion. However as i am new to SQL i think it would take to long to learn to use ssis and remake the whole proc.

Maybe on my next project.