Cache for DTS Lookup Table

  • I am interested in using a Lookup table in one of my packages.  But for curiousity sake I would like to know where the data is cached

  • The reason for my question is that my supervisor believes that using the cache hurts the overall performance of the server.  But if I don't cache the lookup table my package takes ten times longer to run.  I really could use an answer if anyone has one.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply