Thank you for explaining that, it makes sense now!

Do you know if the implicit conversion it's doing is converting it to numeric(1,1)? Is that the default?

The "does not work" was only a placeholder, I don't think that part matters. I put in the number 1 and it'll still fail, but only if the @p1...

It is an offline rebuild. I wonder if there was something that might cause it to be blocked but I wasn't the one that stopped the job at the...

The process will just do one sheet at a time. When that is done, then we start the process again by specifying the next file. The table gets...

Awesome, this is exactly what I was looking for! Thank you!

So I spoke too soon, the issue came back today. Customer called and said the error is showing up again. I have opened up a ticket with Microsoft...

I just wanted to updated everyone and say that we have found the issue. It was a memory issue, the server had AWE enabled but it didn't...

Yes, i have googled it extensively and there were a few posts on the same issues that I have where the problem goes away once i reboot the server but...

Thanks for the ideas. I have tried copying the file and then deleting the original file to see if that'll give me any other messages. I was able...

I have checked and no one has the file open. It actually gives me a different error if the file is open, file not found, etc. I just...

Yes, this was previously working and the distributor server is the same as the publisher server.

The service account is still valid so i don't think that's the problem. The server is...