You are welcome!!!

Can give post the print screen of the error as an attachment?

I have utmost three such posters in my mind right now..., and thanks Bob for letting me know about.

When did you get that error? Is it on executing on the package or parsing the query? (I think later is the case here)

Try setting the BypassPrepare=True and...

Bob,

I agree with you on all of that. Such posters does not deserve any help unless they change their behaviour. But the problem is, one can't be...

GSquared (4/6/2009)

If it had come up in an interview, I would have had to say I don't know what it is. After the interview, I'd have tried to look...

Personally, I don't have any problems in postings of interview questions or even homework questions, given the fact that the OP must have tried to solve it before posting. ...

What errors do you when trying to connect to "http://localhost/reports/pages/folder.aspx" from the server?

Have you given the required permissions to access report server?

Have you tried accessing the report server using SSMS...

I don't think so, it gives the results in just 2-3 seconds on my machine on any given day. That's good enough for me considering the amount of data...

If you are using BIDS or VS 2005+, go to report project properties and set the "TargetServerURL" and "TargetReportFolder" properties. Then right click on the report and select deploy....

Honestly, I don't like using the parameters option of Execute SQL (because of it parsing & execution issues). Instead, I store the SQL text in a variable and pass...

Incremental Population is a scheduled task, whereas Change Tracking AUTO is a continuous running process that tracks the tables/indexes activity and relatively populates the full-text indexes.

BTW, here is online MSDN...

I don't think so it's possible to set the memory limit or buffer pool memory for each database in SQL Server. SQL Server is smart enough to allocate enough...

Are you sure that you can connect to the same instance while you are in VS 2008? If the Object Explorer does not list those databases, it probably means...

Are you looking for Package Configurations to set values for Package Variables?