SSIS needs a concrete table to build metadata from when designing the DFT. Try using a concrete table for design then changing the package to use a temp table at runtime using Variables and Expressions. You may also need to set DelayValidation to True on some components so it does not try validating the metadata until execution.