We have a group who's sole responsibility is to write reports.  They are supposed to be doing data analysis, but that's another subject.

None of them have any technical skills, or...

You are using developer edition in a production enviroment?

My ears, my eyes, a yellow legal pad, a few #2 pencils, and a whiteboard.

That's some bad code there Mike.  I've seen some similar, but add a couple UNION statements and all with in an SSRS report.  Talk about slow code.

I've also had...

Hi Jeff,

Finally got my package fully functional and working another question is the report I'm sending weekly  as of right now my subject line shows 'DC Transfers Report' how...

I'm dealing with a crappy proc, and a crappy design, right now.

The devs did the "Code first" design.  In other words, the ORM designed the database for them.

I can't post...

oh man i wish i was in that...

Is this a good example of someone who may have picked the wrong thing to do with their lives?

https://www.sqlservercentral.com/forums/topic/ssis-package-error-22

Hi

Thanks for you helping me out I apoligize but I'm new to programming this language my next question is why isn't any of my data showing up in my...

I do not know who maintains this, but this is the most up to date list of patches for every version:

https://sqlserverbuilds.blogspot.com/

Automatic patching with SCCM is problematic.  If you try...

This is what I use in a lot of places for SQL jobs.   Not elegant, but it works.

On my newest set of AG servers, when I create a job that...

I'm sorry.  You have now spent what, two days, trying to make this work, and in every case it was syntax errors?

If you correct the file name error in the...

Please look at your code, and the error message

The error says that this file name is invalid:

C:\inetpub\ftpuser\WESA\ftpwashingtondc\DCWeeklyEmail\dc_weekly.csvdc_weekly.csv 

Your code is far too complicated:

set @FilePath = 'C:\inetpub\ftpuser\WESA\ftpwashingtondc\DCWeeklyEmail\dc_weekly.csv'

set @EmailAddress =...

Does this look correct:

C:\inetpub\ftpuser\WESA\ftpwashingtondc\DCWeeklyEmaildc_weekly.csv.csv 

I guess the next question is why?  The slash "\" is being treated as an escape character.   I think fixing that error is the first step.