You can get the actual error message from the maintenance plan - trying to get the error from the agent job is useless.  In Object Explorer - open the Maintenance...

Before going down this road - what problem are you trying to resolve by enabling read-routing?  If you are having issues with select statements blocking writes there may be other...

You will need a separate script for EDIFACT files - but using the idea's from the original script.  In the original script we are parsing the first and second row...

No issues - for AG you have to install SQL Server to that host and not to the cluster, so it doesn't matter the order you install the clustering services. ...

It appears that one or more databases in the AG are not synchronizing - you need to fix that before you can do anything else.

As for the application, did you...

The cname will only resolve to an IP address - the port definition for the named instance won't be included.  If you have named instances you can use the cname...

I ran into another file format for the EDIFACT in files... They all appear to be ASCII files

sample: UNB+UNOA:1+UCH:ZZ+XXX:ZZ+YYYYYY:2200+12194++ZZZZZZ'UNH

XXX - is Sender YYYYYY - Date ZZZZZZ - RecordType

First record...

I provided both - either load directly to SQL Server file by file, or create a CSV file and then load...

A couple of things - not tuning advice, but could help identify possibilities:

1. Don't include the database in 3-part naming - if the code is running in the context of...

This might get you started:

# Encoding check arrays
[byte[]]$utf7 = 43,45;
[byte[]]$unicode = 255,254;
[byte[]]$utf8 = 239,187,191;

# Get list of files
$fileList = Get-ChildItem -Path C:\Temp | Where-Object {$_ -like "*temp_edi_*.txt"};

$fileList...

I cannot answer that question - you already seem to have what is needed in SQL, already broken out by field/column.  It seems you have a process using an EDI...

In Visual Studio - create a new Integration Services Project using the template 'Integration Services Import Project Wizard'.  This will prompt you for the Integration Services Catalog and allow you...

Except when you use DISTINCT or GROUP BY - and...

You have to be able to schedule 'something' - so you need a tool that schedules and runs jobs.  Since SQL Server Express does not have the agent then you...

Simple - by default when SQL Server is installed (all Editions) only those members added during the install are granted sysadmin rights to the SQL instance.  Unless someone with permissions...