Upload job + remote desktop on the same server ie:-

123.456.789.123,4444 --> Upload Job

//123.456.789.123/Upload$\TheTwoTextFiles.txt -->Remote desktop.

SSIS packages arealso on the remote desktop.

Have Changed the connection mangers to use DNC paths

\\server\share\file_path

//123.456.789.123/Upload$\File1.txt

//123.456.789.123/Upload$\File2.txt

Still...

I am speechless, Thank you! Thank you! very kind+informative.

More than enough info for me to go on with, again appreciate that.

One last question, i know in this day and age...

Naah mate your spot on.

My intent is to "store the resulting concatenated address in the target table " in address1 , address2 fields.

Also if it's not too much of an...

Appreciate that Bob, it looks good (so obvious :-))

But the reason i am after a stored procedure is that I have SSIS package which each fortnightly exports+tranforms+performs other...