I can give you one solution to this, in the case where your data source is an OLEDB data source and the database entity driving this source changed its emitted...

SSIS's refusal to relearn metadata from its data sources and destinations is a constant, major problem that has been plaguing SSIS for over a decade now, no doubt harking back...

Thanks for your response OPC, but I tried solving this problem using the "install over it" and the "just add more stuff" concepts and they don't work.

You cannot just install...

OK I answered my own question by just doing it, so I'll post my solution as a public service, since the answer to this problem does not seem to be...

By the way it occurs to me that the SQL Server Express installation simply won't support BIDS at all no matter what you do (possibly even if you install a...

Everything has its price. The flip side: I have never seen any other application(s) anywhere, other than ones written by me using this system, that are capable of returning you...

Sorry if this is a multiple post, but I tried responding once and it didn't post. I never did follow up further on this single-audit-table approach to auditing, since it...

I never did follow up further on this. However the subject of comprehensive auditing is covered in another article series on this web site, entitled "writing nearly codeless apps", I...

omarserenity (11/13/2010)

---

I was wondering what the benefits were of having two separate functions for potentially returning all records if the primary key parameter is passed in as NULL, like:

UFTBadmUser##PK (@AsOfDate,...

Brian: Let me illustrate the benefits of the RAP approach with a scenario. Let's say you and I both implement the same application and we have the same user running...

Brian: Your comments suggest to me that you are accustomed to an archiving model that is entirely different from RAP's archiving model, and that you are presuming that RAP works...

Hugo Kornelis (11/4/2010)

---

David Ziffer (11/4/2010)

---

... a query that references an inline table-valued function almost always runs rings around a query that uses a multi-statement table-valued function, for the reason...

wbrianwhite (11/4/2010)

---

wbrianwhite (11/4/2010)

---

Several problems. 1, what is @AsOf is a future date? Your function returns nothing from live or archive table. 2, the select max audit date...

Hugo Kornelis (11/4/2010)

---

Hi David,

... But in the rest of the article, you only describe routines generated upon primary keys and unique constraints. So technicallly, the developer can still get...

geerobg (11/3/2010)

---

Sorry for the late bump ...

This strategy places the ball in the client's court to define relevant audit information. Generally, an intermediate developer can be tasked with updating the...