Heatwave

breathe

Start by creating an SSRS project in BIDS, then Add >> Existing Item and choose your XML file to add to the project. Then when you open it you...

Why not just keep the table and delete the contents (maybe truncate I am not sure of truncate's impact on replication) and use an Insert Into for the new data?

I wrote a blog on this subject that should help. Also read the comments below for additional strategies to solving the problem.

http://www.bidn.com/blogs/Daniel/ssas/1908/ssrs-dataset-fields-disappear-when-using-a-stored-procedure-with-dynamic-sql-%E2%80%93-how-to-get-them-back-and-save-your-report

While we are dreaming, why stop there. Whenever a holiday is on Wednesday we should get the whole week off. 😀

vertigo

You can do this in the dataset query

SELECT CONVERT(VARCHAR(16),GetDate(),20)

where you substitute your date column for GetDate()

Or you could put this in the Format property of the textbox

yyyy-MM-dd h:mm

If you use data driven subscriptions, you can add a description to the subscription that will help you narrow it down.

I would probably use the parameter values to print on the report for the date boundaries of the report. If for some reason you need to use the actual...

disasters

What error is the agent reporting?

My first suspicion would be that the SQL Agent does not have permissions to query the Oracle server.

I have configured error handling in the wrong scope on several occasions. It is very easy to do unintentionally. Check the scope of your error handler and make...

The error told you about where to look, indicating that you had a problem with your declare statement.

You are declaring Totime nvarchar(8), that should be @Totime nvarchar(8) instead

missing