Thanks for reporting back what caused it. Helped me with something else entirely.

Hi Guys,

I've gone back to the client with regards to it specifically being a sql procedure that needs to do the import.

Waiting on their response now before I go any...

Valuable input is always welcome.

Seems I'll have to complete some SQL courses in the near future along with a lot of practical examples before I take on another SQL based...

Disregard the previous question, answer is located here:

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/f863db04-c84e-4283-8e31-565b46f0803d

Would you consider SSIS to be a better practice?

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...

Would you mind elaborating?

I have never worked with CLR Procedures, I've only read about them and the possibilities that they provide.

I'm quite new to SQL and all it's abilities and...

Hey opc.three,

Thanks for the reply.

This sparked anther thought that I would like to run by you and anyone else who might have more insight into CLR Procedures.

Would it be possible...

I'll give them both a try and see which one works the best for my situation.

Thanks again for all the replies.

Phil

Worked Perfectly.

Thanks for the help, much appreciated.

Phil

Thanks,

I'll report back if it worked.

Appreciate the help.

Phil