Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Bird SQL Overview SSIS Package III - Full Package RE: SQL Overview SSIS Package III - Full Package
David Bird
SSCarpal Tunnel
Points: 4669
More actions
March 5, 2010 at 9:36 am
#1129270
The scheduled job in the second step creates the temp tables on the local server. This allows the SSIS package to start.
Then when an item in the package connects to a remote instance the TEMPDB table is recreated on that instance.