Are all of the CSV files structured the same?  The same number of columns - the same types of values for each column?

If they are all the same you can...

I am wondering why you think freeing up 500GB of a 2.5TB database is actually useful.  That extra space is going to be utilized by SQL Server for various operations.

For...

Just as a side bar, I generally don't mix meta data (headers/footers/line counts, whatever) in fixed field format files simply because most people on the receiving end have problems...

well.... kind of no headers as such.. but for many such files you do have a "header" record with a particular fixed format, then "data" records with their own...

To send an HTML email - you have to provide the html code in the body of the message.  Whether you build out that code manually - or within your...

I did not follow everything you did...it seems that your real problem is how to use SSIS to export to a fixed width file.

First, a fixed width file generally does...

I think the reason your version is blocking itself is the self-join - and the derived table.  Locks have to be taken out on each 'copy' of the table and...

What does this mean?  Did you get an error - if so, what was the error?

Here is one way - but I am sure there is a better/faster method:

Declare @testTable Table (testString varchar(30));
 
 Insert Into @testTable
 Values ('123.1.4'), ('123.12.5'), ('123.12.3.5');

 Select...

Shoot - I usually see the STUFF option but missed it on this one...and putting in the 'T' was on my mind but it is getting late 😉

You can do this without the function:

Declare @startDate date = '2020-05-08'
      , @endDate date = '2020-06-22';

    Set @startDate =...

Declare @dateString varchar(30) = '2020-04-29-14.41.26.686978';

 Select *
      , DateOnly = left(d.dateString, 10)
      , TimeOnly = substring(d.dateString, 12,...

There is one additional parameter (at least) that is required here.  You need to specify the database where you want to execute the code.

 , @execute_query_database =...

To be honest, I think that all'y'all 😀 are making this a whole lot more complex than needed.  The PK on the table is an identity column.  That means...

Have you tested using the procedure with the oldest available date?  If so - how long did it take to delete the data?

It is also possible to add an index...