take a look for a tool called RSScriptor that will do the job for you

best way is to restore the backup to a new database name and then copy the data from the backup to the live DB, you wont be able to use...

couple of things and sorry if you cant do this either but you only detail no changes to the current databases.

could you not create a secondary version of the DB,...

what happens if you tell it that the remote path is not a variable and then set the expression on the remotepath property of the actual FTP task

Very true, but I wouldnt know what to do with myself for the two days...

yeah, looks right, just make sure you wrap stings with " " then hit evaluate expression to see if it does what you want it to do

"/pub/Cell_Availability/" + (DT_WSTR, 4)...

no it wont work as you are not adding in the "-" inbetween the date parts

the below will only give you /pub/Cell_Availability/20120404

2DayWeekNextWeek 🙂

again please do not cross post

all replies here please

Thanks for the clarification Gail, much appreciated as always

Sorry Gail, maybe my terminology is a bit off.

Please correct me if I'm wrong, but when there is a column which is required in the result set which is not...

wrap the dates in a convert/cast function using a format code

eg

CONVERT(DATE,MAX(DATE),103)

CAST(MAX(DATE),DATE,103)

please do not cross post

all replies here please

Might need a bit of work to get it to how you want it, but the basis is the same

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';'...

you will need business intelligence development studio installing on your machine to develop the RDL files, this can be installed via the SQL media if not already done so