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

Maybe, but it shouldn't be for long unless you have a huge number of emails per day.  Of course, you would have had the same blocking (short and sweet)...

I did not include the progress table...you can add that in if needed:

    Use msdb;
     Go

    Set...