一千萬個為什麽

搜索

從差異服務器上的源中加載SSIS中的臨時表

如何通過從Dataflow任務中的服務器A讀取數據來在服務器B上加載Temptable。

替代文字http://img405.imageshack.us/img405/7127/temptable.gif

最佳答案

The short answer is don't do it. SSIS & Temp tables don't mix. There are ways around the problem but they aren't maintainable or scalable. Use a physical table and truncate it at the start of the task flow.

轉載註明原文: 從差異服務器上的源中加載SSIS中的臨時表