Thank you, Appreciate the effort.

Taking into consideration what you've just said, it's forcing me to rethink what I am trying to achieve and that's always a good thing. :unsure:

It does however enforce my original post.

What I am creating now will be used in future to import excel documents into their database and on their demand has to be a sql procedure, which does limit my options considerably.

Would I be able to access a cells hyperlink through SSIS?

Thanks again.