You should cluster the table on:

( Material_Werksdaten_key, TimeDayId )

Your join is very confusing.  You need to specify the TimeDayId(s) directly, not use a function on it.

Is TimeDayId one value...

ah well. didn't notice SQL Saturday was this near me (I'm in Dublin) - would have gone there if nothing else to talk with some people from here.

what everyone else said - plus in some of the teams we have a database per change request being done.

one of our teams has almost always over 100 active databases...

Based on what you said I would change the table itself and have 2 new columns made up of the year and and month part of TimeDayId so the index...

thats SSIS for you - happens a lot unfortunately and I never managed to find a solution.

try with the 2016 runtime and see if it improves. https://www.microsoft.com/en-us/download/details.aspx?id=50040

if it still fails...

time for you do do a bit of data analysis and decide what you want to do with it.

look at the values from the sql below - some of these...

other aspect - assuming that you did install the correct driver on your SQL Server and that your cms is using the defaults then the syntax should be

select *

from cmslinkedservername.cms.root.hagent...

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...