drop kick

I haven't tested this, but give this a try.

Change your derived column to DT_I4, you don't need the larger integer.

Try this expression (DT_I4)(REPLACE((DT_WSTR, 10) (DT_DBDATE) CallDate),"-","")

Are there any similarities in the formats so that they can be tested and grouped into different processes?

For example if you have 20 spreadsheets.

-3 of them have the same 10...

"Stock Rec " + (DT_WSTR, 10) (DT_DBDATE) DATEADD( "DD", -1, GETDATE() ) + ".csv"

I believe it is generally a good idea to set up SQL Server authentication with a service account specifically for SSRS. Then use that account to connect to your...

1. Try using the ReplaceNull function in your derived column

2. Set the error handling and truncation for that derived column to Redirect Row, and then give the Derived...

Snapshots save both the data and the format of the report. I don't believe there is any way to associate a new format with an existing snapshot. If...

worm

sleep

It could be the job on the server is running under the security instance of the SQL Agent and that it may not have access to the target server. ...

We are still overwhelmingly on 2008 R2, but we have a few new projects moving to 2012.

turner

DC

If you are using the Enterprise Edition you should consider a Data Driven Subscription.

This is a common enough occurrence in the real world that I built a function and embedded it into my report template so it is built into all my reports.

http://www.bidn.com/blogs/Daniel/ssas/1245/divide-by-zero-tweak

Make...