Categories
T-SQL Tuesday

T-SQL Tuesday #201 – Temp Tables, Friend or Foe?

For August’s T-SQL Tuesday ask, Jeff has thrown temp tables to the wolves. Does the community like or loathe their usage? I’ll predict a few ‘it depends’ responses, and I lean towards Jeff’s position that they’re more of the exception than the rule. I’d argue there’s one particular scenario where this exception becomes exceptional (heh). Building optimisation boundaries […]

Categories
SSIS

Wrestling with Temp Tables in SSIS Data Sources

When handing data we can make use of temporary tables to aid with separation or performance. However, they don’t always play nice with Integration Services packages. If we set a source to call a procedure returning the contents of a temporary table we’ll see an error like below: The process is unable to determine the […]