开发者

Loading Temp Table in SSIS from source on differenct Server

How can i Load Temptable on Server B by reading data from Server A in Dataflow task.

alt text http://img开发者_运维知识库405.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.


Why do you need to write to a temp table? You can simply perform any transformations you need on the buffer in memory and then write out to the final table. It is notoriously difficult and usually not worth the effort to write out to a temp table in SSIS. See this blog entry from Jamie Thomson about how to do this, but take note of his warnings at the bottom of the post:

http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜