Use a Derived Column Transformation in your dataflow, use UPPER as part of your expression and replace the column instead of adding a new one.

Just to check, are you entering "Jørgen Ørum <jørgen@ærø.dk>" as the email address? You only need to enter the email address, separated by semi colons. For example: jørgen@ærø.dk;jeroen@ærø.dk.

To do this, you would need to use dynamic SQL, such as:
DECLARE @Field_suffix char(1);
DECLARE @sql varchar(MAX);

SET @Field_suffix = '1';
SET @sql = 'SELECT A.REG_NAME,val_alpha'...

Fixed your formatting for you...
SELECT count(*),
       (CASE WHEN wfstate =0 THEN 'Submitted'
             WHEN wfstate =30 THEN 'Duplicates'
   ...

I'd hazard a guess that your dates are in the format 'd/M/yyyy' (for example 4/5/2017 (4 May 2017), 14/4/2017 (14 April 2017), 5/12/2016 (5 December 2016)) , and likely your...

Duplicate of topic: https://www.sqlservercentral.com/Forums/1874393/error-1418-when-I-start-database-mirroring

I', really not a fan of it either....

Something like this?
CREATE TABLE #FilePaths (FilePath varchar(500));
GO

INSERT INTO #FilePaths
VALUES
  ('C:\ABC\DEF\BANK'),
  ('C:\ABC\DEF\ACCOUNTS'),
  ('C:\DEF\ABC\EXPENSE'),
  ('C:\ZYX\WVU\INVOICES');
GO

SELECT *
FROM #FilePaths;

First thing we probably really want is what your SQL for your procedure is. At the moment we have a "works like this" statement, but that doesn't necessarily tell us...

Hazarding a guess here (sorry for formatting, SSC still hates my paste and I can't be bothered to fix it). I'll admit,this does it in two passes, not great, but...