CODEWITHSUNDEEP
ssismergetemp-tables
Sreedhar
Sreedhar

Reputation: 30015

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://img405.imageshack.us/img405/7127/temptable.gif

Upvotes: 0

Views: 1351

Answers (2)

Kevin D. White
Kevin D. White

Reputation: 1213

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.

Upvotes: 2

William Salzman
William Salzman

Reputation: 6446

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

Upvotes: 1

Related Questions