Does the All Executions report give you any additional information? It should tell you exactly which component is failing, for example.

Am I missing something obvious here?

The Job is...

Thanks Phil for your quick response and if its detected that will help for application team to check it further.

even we can avoid any issues from  SQL server side

I...

I'm with Thom.

Sounds like a Flat File Source, to a staging table, followed by one or more ExecuteSQL tasks to fire off the stored procs you need to process the...

What do you want to happen if a long-running job is detected?

OK. I think your problem may be down to the fact that your

public void Main()

should be contained by

public partial class ScriptMain

and not by the Program...

What do you want to happen in the event that a request to execute a package is received, but the 'maximum concurrent executions' number, whatever you deem that to be,...

If you check the Script Task's properties, what is the EntryPoint set to?

That really helps, thanks.

This is a rather nebulous request.

Which part of this would you like help with?

This is close, I think:

DROP TABLE IF EXISTS #SampleData;

CREATE TABLE #SampleData
(
    Name VARCHAR(500)
   ,Timestamp DATETIME
   ,Result INT
);

INSERT #SampleData
(
  ...

Yes there is. You need a Data Conversion transformation.

Please provide your sample data in the form of CREATE TABLE/INSERT statements, if you would like to receive a working solution.

I do not understand what you mean by 'unmatched' here....

With > 3,000 points, I assumed that you'd know that a request for sample data does not mean 'please provide a screenshot of a spreadsheet'. That's assuming you are asking...

How about the disorderly orderedness of the...