I posted a function that calculates the 4-5-4, 5-4-4 and 4-4-5 calendars for a 3 year period here: https://www.sqlservercentral.com/scripts/fiscal-retail-4-5-4-calendar-function

If I am understanding your request - you need to figure out...

Not enough information - and not real sure what problem you are encountering.  Is there an error?  How are you calling this stored procedure?  Where does the stored procedure live?

If...

"837" files are an EDI specification.  They can follow either an EDI format or a similar format in XML (but usually not the later).  I wish the world would...

Why are you using SQL Server to send an email with an attachment - when the file is created in SSIS?  Why not use the built-in SSIS email task?

I have to ask - why does the developer want to create an agent job, execute it - then drop it?  What is the purpose behind this request and how...

Also - verify your auto growth settings.  They should be a fixed size in MB and not set to the default percentage (or default 1MB which is way too small).

If you are actually looking for the latest file that matches - it can be done this way:

$searchDate = (Get-Date).AddDays(-1);
$ZipDestinationPath = "\\my\nas\Share\Path\";
$searchString = "MyFiles_" + $searchDate.ToString("yyyyMMdd") +...

As for best practices - I would say (and recommend) using the Integration Services Catalog.  It provides the best options for securing your projects and packages, allows for managing the...

Neither of the examples are meant to be run from SSIS - they are meant to be used in SQL Server Agent.  They can be included directly in the job...

Why did you start a new thread?  The answer to your issue is in this thread: https://www.sqlservercentral.com/forums/topic/ssis-83#post-3729970

I provided 2 separate examples...both of which can be executed directly in a query...

The other option is to add a new job step - setting the job step to quit with success on failure.  On success - the job step will...

Verify the language your browser is using when downloading - it may be set to US English which is why you are only getting that version.

Don't fail the jobs on the non-active instance...that just introduces a lot of error messages and problems.  Instead - check for the node being primary and if so...execute the task(s).

This...

You cannot connect SSMS to a different version of SSIS.  If there is a requirement to use SSMS to access SSIS then you would need the 2016 SSMS to be...

Depends on how you are setting up your DR system.  If you are going to use some method outside SQL Server to replicate the data to the DR site then...