• 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.

    David Bird