No. The copy is sql 2005 on sql 2012 sp2

Unfortunately no.

Yes it is sp4

Microsoft SQL Server Reporting Services Version 9.00.5069.00

All versions are Standard Edition. And eeing this message when connecting to the RS databases via Reporting Services Config Manager

The results are the same. for XP_logininfo - this is the results

Account name type privilege...

So it turns out it has something to do with the indexed views associated with the table. The work around was to drop the views do the bulk insert...

I have a question about storage. I have a 3 node windows cluster. 2 FCIs on san storage and 1 node on a separate san. For Always...

So it looks like the issue is the actual bulk insert. It won't complete. But if you use an execute sql task just doing a regular insert it works....

I have looked at the execution plan. That is not the issue. I have attached a picture of the tasks

I have been doing this for a couple of years now and have never had this problem. Backups and restores are a possibility but when you have over 15000...

Thanks Grant for the information. I'll have to look into see if openquery will work for us.

Thank you so much. I always forget about the case sensitive property of xml

Exactly.

thanks. I found the funky data. I hate when its something so stupid. I appreciate your help and time.

Yeah that would have made more sense just to do the select from the table. I apologize for the confusion. Conversion failed when converting the varchar value 'NaN' to...