Check your Excel source if it's for the right version of Excel file

Thank you! That's what I was missing together with changing

SELECT '-2' as Gruppe, '' as Ordering_Dealer_ID_Prev

to

SELECT '-2' as Gruppe, '0' as Ordering_Dealer_ID_Prev

looks very promising...

tsql is not really useful here I think, have a look at this PowerShell Script instead

$disks = gwmi win32_diskdrive
 
foreach($disk in $disks)
{
    $disk.psbase.getrelated('win32_scsicontroller')
}
$disks |...

with do (DealerGroupOld, DealerOld)
as
(Select Case when a.Gruppe is null then 'Einzelhändler' else a.Gruppe end, f.Ordering_Dealer_ID_Prev
from dbo.D_SalesOrg left outer join (
SELECT HNR, Gruppe from STG_Dealer_Groups
) as a on...

sure I have, here you go:

USE [TestDB]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[STG_F_Sales]
(
[PK_Sales] [bigint] NOT NULL,
[FK_PrevSales] [bigint] NULL,
[Commission_ID] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ModelTypeFull_ID] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT...

Right, sofar I've got the following script:

with do (DealerGroupOld, DealerOld)
as
(Select Case when a.Gruppe is null then 'Einzelhändler' else a.Gruppe end, f.Ordering_Dealer_ID_Prev
from dbo.D_SalesOrg left outer join (
SELECT HNR,...

You're right, I've removed that from the script.

I will get back with performance numbers tomorrow (once the daily load is done). I've changed 2 Script Tasks with your help to Script Components, one does show quite dramatic...

found it myself,

this.ComponentMetaData.FireInformation(3, "Process Values", "Processing Done.", "", 0, ref fireAgain);

this is what I need instead of FireError in the first occurence

Hi Frederico,

thank you very much, you're awesome! 🙂

I still have one minor issue, I think I miss some sort of ProcessingEnds handler or something because he does process all the...

turns out it seems easier to convert a Script Task to a Script Component than it actually is - if you have no clue about these things like me.

I'd love...

sounds good, thanks for the input I'll try and see if I can get that running.

No,  the GT_Versandweg table is not created externally but we're essentially limited to being provided the data you see in the first post - except for the unlock events. Data...

Did Cluster Validation show any Errors or Warnings?

literally 2 days ago I was asked why the "Manual Corrections...