---
title: "Discussion on \"Use Stored Procedures with Temporary Tables in SSIS\" | Hashnode"
description: "Discussion on \"Use Stored Procedures with Temporary Tables in SSIS\". PROBLEM: if you try to execute with a SSIS Data Flow a stored procedure containing a temporary table, you receive this error message:\nException from HRESULT: 0xC020204A Error at From SQL Server to Excel [OLE DB Source [91]]: SSIS Error Code DTS_E_OLE..."
url: "https://hashnode.com/posts/use-stored-procedures-with-temporary-tables-in-ssis/6102d22c805a765b08874f22"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Use Stored Procedures with Temporary Tables in SSIS](https://massyfigini.hashnode.dev/use-stored-procedures-with-temporary-tables-in-ssis?utm_source=hashnode&utm_medium=feed)

PROBLEM: if you try to execute with a SSIS Data Flow a stored procedure containing a temporary table, you receive this error message: Exception from HRESULT: 0xC020204A Error at From SQL Server to Excel \[OLE DB Source \[91\]\]: SSIS Error Code DTS\_E\_OLE...

Aug 6, 2020 · 1 min read · massyfigini.hashnode.dev  
Updated Sep 2, 2024  
Read the article

-   [#sql-server-integration-services](https://hashnode.com/tag/sql-server-integration-services)
-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#ssis](https://hashnode.com/tag/ssis)

## Written by

[Massimiliano Figini](https://hashnode.com/@massyfigini)

@massyfigini

  
[View profile](https://hashnode.com/@massyfigini)

Data Enthusiast

data engineer • T-SQL developer • r and python • Power BI and tableau • machine learning enthusiast • data lover Follow back granted

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
