My apologies for never following up and closing out the issue.  Here is what happened 4+ years ago.

We received a new server and installed SQL Server on it....

Thanks so much for the detailed explanation, it worked like a charm. From a usability standpoint, I'm disappointed that it is so complex to implement but I now understand...

Thanks. I finally figured it out by moving my attributes to a Dimension table and using a key to lookup the value that way. I then created a...

Thanks for the responses.

Regarding the data types - they are:

1.) char

2.) varchar2

3.) date

4.) number

We tried a mixture of columns in our openquery and if we bring it down...

The problem was the pass-through (openquery) query was pulling in a numeric(18,3) field and casting it as a nvarchar. I had a line of code in my select statement...

Thanks Elliot. I'm going to break it down to 10 column increments like you suggested and see where it is failing.

Also, I get the exact same error when I run the openquery in a query in Management Studio but again no row failure or column that it failed on. ...

Thanks Elliot. It is pretty clear to the issue but it doesn't provide which column failed. There are about 50 columns in the extraction and all the data...

Bare with me, I am a newbie to SQL Server security.

I have a database with a multitude of tables all owned by dbo. I want to create a role...

thanks a lot for the expert insight. I will setup with that format - thanks again.

You can write a UDF that receives a string and returns the string enclosed in single quotes. In your SQL code, you have a re-usable function that you can...