Thanks again. The additional information is good to know for future clean ups especially when the users catch on to the data driven subscriptions. For now only our reports developers...

Thanks Daniel. It filled the ticket!!

Congratulations Tracy!

I am a bit disappointed in the article's extreme brevity of the technical aspects of her accomplishments: what about transaction rates? Use of the data? Types of databases?

We also have an "ACL", but it provides access control through the main application rather than Report Manager. These users see an interface which captures their location and ID to...

This method is good for a small and stable pool of users and reports. However, we find it more practical to control access through AD groups. We are too short...

John,

The trace was started and the SQL statement looks like the same statement that I pasted into the OLE DB Source.

I have developed an alternate solution: instead of...

Elliot, the connection between the Source and the Destination does not reflect a count, the task boxes just turn green and the insert count for the Destination is Zero.

Other similar...

Been in the business for quite a while, and have no certifications. It did not prevent me from consulting / contracting and otherwise be consistently employed. I may have seeked...

(Oops!! correction at the end of the post in bold.)

Interesting Read! Good article! and a clever use of an "old" method.

Comment on the "The Temp In-Place Method". In those days...

Interesting Read! Good article! and a clever use of an "old" method.

Comment on the "The Temp In-Place Method". In those days we also worried about the machine cycles used, so...