Jonathan,

Thanks for that, however these tasks are run in a for loop container,

so unfortunately it would work in this case.

Hi Phil,

So under normal circumstances this wouldn't get run at all,

the package consists of 64 data loads Tasks (3 party data).

Following a successful load of each of these tasks, we...

• This reply was modified 2 years, 9 months ago by  Simon Hundleby.
• This reply was modified 2 years, 9 months ago by  Simon Hundleby.

I'd Like to know what world the 15% that didn't answer the grinch are living in?

Thanks for your help with this Jeff,

We now have a sprint to disable all the MARS connections.

Hi Jeff,

Thanks for your quick response.

A couple of things, firstly I have seen sp_GetAppLock running during 100% CPU utilization,

I stupidly dismissed this as nothing to worry about.

Secondly I spoke with...

• This reply was modified 5 years, 1 month ago by  Simon Hundleby.

Jeff,

Yes I didn't explain the requirements as well as I could have.

Yours and Des Norton's solutions both fulfilled the requirements.

Thanks again.

Thanks to everyone who helped

with this. I'm just working through them to understand how each one works.

Regards,

Simon

Jeff,

Thanks for this very elegant solution.

Regards,

Simon

Des,

Thanks,

Perfect solution.

I've been struggling with this for the last 2 Days.

Regards,

Simon

Des,

Works perfectly

Thanks.

Thanks Des,

That Table is just static showing  the Start and End Months.

It will not be available in Production.

Using your function still gives me incorrect dates when I use the following...

ShortMonthNameMonthStartMonthend
Jan2018-12-312019-01-27
Feb2019-01-282019-02-24
Mar2019-02-252019-03-31
Apr2019-04-012019-04-28
May2019-04-292019-05-26
Jun2019-05-272019-06-30
Jul2019-07-012019-07-28
Aug2019-07-292019-08-25
Sep2019-08-262019-09-29
Oct2019-09-302019-10-27
Nov2019-10-282019-11-24
Dec2019-11-252019-12-29

Basically I want to be able to pass in a date and it calculate the Correct month Start and End as in the table above.

The difficulty I...

Thanks for all you replies,

However none of the solutions seem to work.

For example if I pass in '2019-01-28'

I would like it to return

Feb 2019-01-28  as monthStart   2019-02-24 as MonthEnd

As '2019-01-28'...

That's going to be a massive benefit, We have 100's of packages, that we are...