Dumb question: Sanpshot reports

Will a report based on a scheduled snapshot send itself out (either to an email or data space) if the data in the new snap shot is the same as the previous?

If so is there any method to only send out a report if the data has changed?

And if not what do most people use snap shot based subscriptions for?

Thanks.

1.) Yes.

2.) You can try to use Data Driven Subscriptions. What you will have to do is have the query which generates the list of recipients detect if the data has changed, and return an empty set if this is the case. SSRS will not really help you do this, so you will need to cook up your own way of determining if the data has changed since the last report went out.

DTS to run open file

Hi All

On the Sql Peformance Monitor, I have scheduled a log to give me memory and perfomance of my server and I store the results in .csv file every hour and it works perfect.

Here comes the problem when I make a DTS to take data from .csv to Sql, my problem is, I get this error "The process cannot access the file because it is being used by another process". Basically it tells me that I have to close the file before I can run my DTS.

I dont want close this file manually and run my DTS afterwards, I want my DTS to do this automatically since I won't have access to that server when I am finished as I am going off from the clients premises when I am finishedOriginally posted by msenoelo
Hi All

On the Sql Peformance Monitor, I have scheduled a log to give me memory and perfomance of my server and I store the results in .csv file every hour and it works perfect.

Here comes the problem when I make a DTS to take data from .csv to Sql, my problem is, I get this error "The process cannot access the file because it is being used by another process". Basically it tells me that I have to close the file before I can run my DTS.

I dont want close this file manually and run my DTS afterwards, I want my DTS to do this automatically since I won't have access to that server when I am finished as I am going off from the clients premises when I am finished

Hi,

maybe it is possible for you to make aa copy of the .csv file and get data from this copy??

Lambik|||Thanks, I did that and it worked perfectly