Using Temp Tables Across SQL Tasks - SSIS
ssis we have connection pulling. So each task has a connection and the temporary table is available till the connection is their.
In "Connection Manager" , set the "Retain Connection" property to "True" then throughout that connection is used the temporary table will be available.
No comments:
Post a Comment