the problem is trying to solve the following:

The model for this sql code is MS Outlook's Recurring settings for the Week option and not the Day option or the Month...

Hi Experts,

I walked away for a minute and I figured out what I did wrong.

I assigned the wrong value to my declared variable called @NewOccurEndDateType.

You can see what I did...

Thanks William. It looks as though you are probably correct considering the lack of info.

Hi, I am back for a second.

I did google AQL and I think that it has to do with MS SQL Svr 2008 SSIS but there isn't much info. ...

Oh and I didn't mean to sound ungreatful for the other suggestions.

Thanks you too MiKe.

I found an entry on one of the other thread from the guy from Austrialia. Just add the fields manually. This actually worked.

Thanks to the guy...

I have tried all that has been suggested so far. Non of this has worked yet. The solution is coming. I do have a few SSRS reports...

I have taken a look around and your are right about others having a similar issue. I did modify the stored procedure to using a regular table but that...