Try couple of things. First just execute it see weather its giving the same error message? if its a different error message then you have an issue with the permission....

WOW!

Declare @StartDate char(10), @EndDate char(10), @ReportDate char(10),

@MonthStart smalldatetime;

Set @MonthStart = DateAdd(m,-3,GetDate());

Set @StartDate = LEFT(Convert(char(24),@MonthStart,120),7) + '-01';

Set @EndDate = LEFT(Convert(char(24),DateAdd(dd,-1,

DateAdd(m,1,Convert(smalldatetime,@StartDate,120))),120),10);

/***********************************************************/

Above...

Well,

Actually this Active X script was creating a global variable in SSIS package and use that global variable to execute stored procedure and then load data in temp table and...

Here is the code:

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

dim bDate, tDate ,StartDate, EndDate, ReportDate

StartDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -3, +2))

EndDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date)...

DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))

When I run this query on 29th January it gaves me 10/01/2010.

When I run it right now on 02/01/2010 its giving me 11/01/2010.......

Yes, It is just a code from Script task in SSIS. I got these code from one of my SSIS package in that he set a date variable then execute

stored...