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

Hello, I'm not sure if I'm even phrasing this correctly, so please excuse lame or novice comments 🙂

Infor: GL Account numbers have a location identifier. For example position 11-13...

Seems like a lot of work.

Presumably you have considered:

1. Back up the databases to an external drive
2. Do a clean install of W10 and SQL Server 2017
3. Restore the databases

...

Hello. I want to get address a folder like "D:\MOVIE\March 2019" in SQL SERVER DATA TOOLS and zip that folder and then copy it to the desktop after zipping?...

i have a variable value that coming from batch file as N and Y

in the package i kept hfcol  as string  . there is another variable in the package...