Another approach would be the CASE statement, so something like:

CASE WHEN Person.Termination_Date IS NOT NULL THEN 'N' ELSE 'Y' END

I prefer CASE statements over IIF's, but you...

As a thought, are you ALWAYS having that format?  What I mean is an open bracket, a single character, a closing bracking a space, the name, a space a -...

Not a problem.  I imagine there are other solutions as well.  If you KNOW you are wanting NVARCHAR for sure, you could also do a REPLACE on the utf-8 to...

I would start by checking the logs (windows and SSRS) to see what is happening.

Next, I'd load up the browser debugger to see if any errors are showing up in...

If the columns are MOSTLY 'N/A', to me that sounds like a very poor key.  Now, if you are going to overwrite that value with a SEQUENCE or IDENTITY value...

Any luck running SSMS as administrator?

I am just reading the error that the object has no columns (possible, but unlikely as it works on the old system) or the current...

Was doing a little bit of random testing on this and I think the problem is that utf-8 is going to be VARCHAR.  utf-16 would be NVARCHAR.

This is easy to...

I have a thought (may be WAY out to lunch, but just want to suggest it anyway) - what happens if you run SSMS as an administrator and then run...

My guess then is that you may just need to wait for SAP to provide you with a driver that works with SQL Server 2019.

I am guessing that the DBF...

Do you have the same issue if you use the ACE.OLEDB driver or is it a different error?

Or failing that, what about the Visual Fox ODBC driver?  It looks like...

• This reply was modified 4 years, 7 months ago by Mr. Brian Gale.

I agree the post is old, but the information is still relevant.

I would check things like it suggests with process monitor to see if MAYBE there is some access denied...

As a thought - are you able to see ANY data or does it return no rows or does it give you an error?

I am not 100% certain, but I...

I would reach out to the company that provided you the driver.  Quick google, a "dbf" file is a dBase file.

Quick bit more of googling and I came across a...

Pretty sure that REPLACE is going to be the best way to approach that, without changing the underlying data structure and manipulating the data.  I prefer to store my addresses...

My opinion - with it being on a SAN, there isn't a lot of need to put it on separate disks UNLESS your SAN admin can guarantee that the separate...