SSIS and Stored procedures using temp tables
SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.
2008-12-26
24,939 reads
Michael Cape
Blogs
Microsoft Announcement: Microsoft Fabric
Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...
Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
Flyway with Multiple Folders
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
Forums
Access db
Access db wanting to move sql server, how much control does business have over...
Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?
I'm trying to create an SSIS package that will query a master control table...
Ask SSC