Without a more detailed error it could really be anything.

I would recommend running the package in BIDS so that you can get the full output so we can debug further.

84gopi (7/24/2012)

Can you help me in getting query to display current week number, previous 9 weeks & next 6 weeks for a year......

I have report requirent to display like current...

2008 has a limit of 4GB

2008R2 has a limit of 10GB.

The key in the error message is

There may be error messages posted before this with more information on why the thread has exited

If you scroll up the output window...

84gopi (7/24/2012)

If I have weekstartdate & enddate, week column in my table......can any one tell me how to write sql to display curren week number, previous 9 weeks & next...

Yes we can help with a SQL query for your requirements, but we will require you to provide DDL, sample data, expected outcome as per the second link in my...

I'm not a Cognos expect, I personally stay away from it as I think you can do all that Cognos does and more in SQL with SSAS SSRS and SSIS...

Ergh Cognos, well that will be a problem as you will need to look at the EXTRACT function instead

Found this for Cognos8 http://www-01.ibm.com/support/docview.wss?uid=swg21345500

DATEPART(WEEK, MERCHANDISING_WEEK)

DATEPART requires the part first then the date to which to calculate the part from.

So you want the WEEK of MERCHANDISING_WEEK

Yep totally agree on that, just half the time the developers create logins which arn't needed so it just adds that extra security step when promoting to test and live.

I personally tend to miss out the SID part when running the script to the other server, just my personal preference.

Hi

Thanks for the information provided, but if you could spend a few minutes looking through the second link in my signature on how to post code and data for the...

login to SSMS and connect to your SSRS server

change the properties of the server to enable remote errors

run the report and post the full remote error

What user have you assigned to the unattended execution account in the SSRS configuration?

If its blank I would recommend setting one up, then any reports which write files on a...

You would need to insert a page break in the report, that way when it renders to excel it will but what ever is between the page brakes in a...