Thanks for the reply, but I'm not attempting to concatenate two NVarChar(4000) fields into a single NVarChar(4000) field.  I'm attempting to concatenate the data in these two fields for display on...

Jonathon, I had tried your suggestion, but it didn't resolve my problem.  Sara, I have not tested your approach.  Instead, as a workaround, I took the following steps: 

1. In my DTS...

I appreciate the suggestion.

Per your suggestion, I typed "clipbrd" in the run command window and received an error message that said "Windows cannot find clipbrd." ???

However, I did try creating...

Actually, I'd like to answer my own question for others that might read this later.  I'm told that we'll have to add the remote IP to the firewall to allow...

Sadly, I cannot ping at this time.  However, our network engineer is on the case.  Soon, my problem will be resolved.

Thanks again for the help. 

Thanks a lot for the replies.  However, I'm afraid I didn't do a good job of asking my question.  I apologize for that.

I do know how to create a connection...

Thanks Kenneth.  I'll read the article, and see what I can find in Books Online.

Good to know.  Thank you.

Works great - thank you.

If, by any chance, you could explain why my original code didn't work, I'd really appreciate it.

Thanks again for your time.

Thanks so much for your reply. 

Per your suggestion, I disconnected, re-connected, and ran the transaction again.  Unfortunately, nothing changed.

I then ran your revised version of the transaction using the...