Temp Tables in SSIS

I’ve been strugglig quite a bit this last week to get my temp tables up and running in SSIS.
But after alot of struggling i finally managed to get it going.
But it took alot of seaching around.

Well in this video i explain the settings that need to change in SSIS to make it work.

I found these 2 links very handy in figuring this one out.
Original Article on Temp table

https://www.mssqltips.com/sqlservertip/2826/how-to-create-and-use-temp-tables-in-ssis/

and the different kind of temp tables out there https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/temporary-tables-in-sql-server/

Author : James Botes

James Botes is a Cape Town Senior Business Analyst (CBAP) with a keen interest in Systems Thinking & Solving Business Problems. Founder and Creator of the site and you tube channel BASensei. Linkedin : https://www.linkedin.com/in/james-botes-73a63b67/

Leave a Reply

Your email address will not be published. Required fields are marked *

8 + ten =