Brilliant!  Thank you Jeffrey.

I will give that a whirl.  I'm fairly new to VS and the SQL Data Tools application so will see if I can do that with the tool.

OH MY GOODNESS.  I changed them BOTH to Encrypt, save all, closed.  Opened it up again, changed Project to Dontsave, then package to Dontsave then save all.  Now runs.  ARgh.

If I select Project at the top then Properties, it's set to DontsaveSenstive.

Very lol

Fixed it.  Forgot to add the Expression into the Source Connection Manager for my variable.  D'OH!

They do have all the same column names....I'm simply changed it from a bunch of *Summary*.csv files to *Detailed*.csv files (the destination has already been changed to reflect the new...

I've deleted both my flat file source and ole db destination and re-added.  Since I'm using a ForEach Loop the flat file source references the flat file connection and not...

I'm doing the changes in VS.  I don't see any options to update column definitions.  If I wasn't using the ForEach Loop it wouldn't be an issue.

I'm so close it's killing me.  Went the function route and found this:
CREATE FUNCTION dbo.SplitStrings
(
    @List       NVARCHAR(MAX),
    @Delimiter  NVARCHAR(255)
)
RETURNS TABLE
AS
    RETURN (SELECT...

Tried this as well:

 SELECT JCCo,Job,Phase,
LTRIM(RTRIM(m.n.value('.[1]','varchar(8000)')))
FROM
(
SELECT JCCo,Job,Phase,CAST('<XMLRoot><RowData>' + REPLACE(REPLACE(ProjNotes,CHAR(10),'~'),'~ ~','</RowData><RowData>') + '</RowData></XMLRoot>' AS XML) AS x
FROM   JCCH
)t
CROSS APPLY x.nodes('/XMLRoot/RowData')m(n)

Msg...

I'm getting there with something like this.  I'm getting "Msg 9448, Level 16, State 1, Line 12
XML parsing: line 2, character 89, well formed check: undeclared entity"
in the...

Inneresting discovery.  I replaced a CHAR(13) with ^ and CHAR(10) with ~ and get this for one field.  So if I replace them first, my delimiter could be "

December 6, 2017 at 12:46 pm

#1971037

Here is the actual data for a few rows:

101 16032.    01910.      NULL
101 16032.  01910.   01 NULL
101 16032.    01955.      NULL
101 16032.    02200.      10/17/2017 11:36:37 AM by User2  This...

Matt and Alan, I totally get it, however, the application/code was written by a third party software vendor and I cannot modify unfortunately. The only reason I need it parsed...