Well, I am a bit worried about myself.  There is a second SQL task that indeed had an unclosed single quote.  I was so tunneled visioned on what I was...

Thanks again everyone.  Thom A:  I have tried putting the string into a variable and passing all three parameters as variables with same error.

Because testing this in its native production...

oh i forgot to mention that of course the sql generated does not run in SSMS but if i just run

EXEC dbo.Integration_RetrieveMessageToProcess 525, 1, 'Billed'

in SSMS it runs

Thank you for your responses.   Here is the error using single quotes.  The sql generated using single quotes from Profiler is above.

I had no idea how badly working over the VPN was degrading VS and SSIS.  Now that I working on local files and syncing them with DevOps GIT source control...

Thanks Thom and everyone.  I am going to try the local files with remote GIT source control.

Thanks everyone for your replies.  I really appreciate them.

The files are actually gone from disk, not just the project.  Really frustrating.

I am working over a VPN (aren't we all?) to...

Thanks everyone for your help!  I am going to investigate your suggestions today and reply with what i find.

Thanks for your responses!   Although i have built many data warehouses this is my first international situation.   I will need answers to these questions from the client before i can...

Oh boy am i dumb.  If it helps anyone else ... when you enter colors with the RGB picker you must also set the transparency.  Otherwise the transparency is 0,...

Using Drew's query and pivot gets me what i want.  Thanks again.

WITH Cal AS
(
  SELECT n, DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE()) - n, -1) eom

Thanks Drew and Chris!  I did handle the column headers in the presentation so they are the actual dates.  I was unfamiliar with "Tally".  Very cool!

I was able to accomplish this mostly.  I could not do it with the actual end of month dates but with the number of months ago.

Not possible?

Wanted to give an update on the final resolution of this.  John's suggestion of a connection string expression worked well but as i was poking around for another reason, i...