does not matter what we think will work - you are trying to extract data from a third party database (avaya which is, as far as I know, an informix...

Frederico,

The issue is, it doesn't work.

I get this error:

Arithmetic overflow error converting float to data type numeric.

When I try this line below:

Case When [Vendor invoice] Like '%E+%' Then Cast(Convert(numeric(24,0),...

is your installed excel version a 64 bit?

you already have the code required - what is the issue with using that code?

apart from a possible precision issue that you should be able to sort by your self...

this is something that you should be asking to the vendor of Avaya.

but that query in Oracle is querying a "db link" - this equates roughly to a Linked Server...

adding to Jeff questions.

when you load each file do you need to know, within the database, what was the file being loaded?

you mention that the file has the custid on...

perfectly normal and expected

Columnstore compression is very high - when you dropped it the table got converted to a heap with no compression ( or with  standard page compression) so...

if they have all the same structure and depending on the size, and depending if quality is guaranteed (eg they are real CSV files, not just delimited files) then you...

when using SSMA my advise on migrations is to do data separately - let the tool convert objects (where it can) and do data yourself - more control of when/what...

multiple things.

• start with archiving the data onto a different server - partitioned by year/month - will help querying in some ways (not so in others) and will make deletes...

put them on the latest compat mode - if there are issues with CE you can change each db that requires it by using the ALTER DATABASE SCOPED CONFIGURATION  (see...

setup some Extended Events to capture all sql alongside host where it originated and username - let it run for awhile and that will tell you whats/who is doing it

please take this as a constructive comment.

had a look at that particular offer - not quite just a DBA - and it mentions skill sets that most DBA's will not...

as I told you if you define the field as a datetime datatype the format you use does not matter - it is up to the UI to do the...

if the fields were defined correctly as dates then the format does not matter

apart from that your code is doing what you asked for