My package does some data manipulation step prior to adding data to the warehouse.

After the manipulation a QA step is performed and the results are sent to Excel.

I was hoping...

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...

I have experienced the same problem and have also solved it by creating a .csv.

Thanks for your help.

Actually this is exactly how i figured it out. The hard part is determining Object names, but Disconnected edit really helps out in this section.

Thanks guys

I do need it after the load. I will try your suggestions.

How lucky I came in looking for a solution of clearing data from an Excel file that is repopulated on a weekly basis. Since Excel does not support a Delete...