CODEWITHSUNDEEP
asp.netssis
user26411
user26411

Reputation: 121

asp.net app still using old data after SSIS Package updates it

I have got a SSIS Package running every 2 hours. It collects data from different DBs and updates the DB of my ASP.Net Application. Everything goes smooth, but the asp.net application is still using the old data, it has the data somehow cached. If I just open save the web.config, it empties the cache and uses the updated new data. How can I make sure, that the app empties the cache after SSIS Package finished successfully?

Upvotes: 0

Views: 161

Answers (1)

dariol
dariol

Reputation: 1979

If this is your code then you should use SqlCacheDependency. If not then you can add special aspx page and call it from SSIS. This page can refresh cached data.

Upvotes: 1

Related Questions