Just a note, in my experience, it seems easier to convert (or cast) the string to date in the YYYYMMDD format as there is no separator involved and this works...

Two questions: is the file open when the package is executed? Does the user that the package is executed under have access to that share location?

I'm not quite sure why it does that but I noticed that also.

I now make it a habit to review the code before any changes and getting rid of "risky"...

Just curious, what's wrong with the SQL or better stated, why can't you use it?

I know this thread is old but did you find the fix?

Just so you know, when you change the report server, and sometimes just with a service pack, the dreaded...

Yes, the service will need to be restarted.

AWE from 2005 Books Online: http://msdn.microsoft.com/en-us/library/ms190673(v=sql.90).aspx

AWE will allow the server to use more than the 32-bit limit of about 4GB. Is there a reason they installed 32-bit over 64-bit? With 64-bit, you wouldn't need to...

It looks like it's taking the original number -...

Try MSDN