求助：SQL视图为何导致SSIS挂起并锁定数据库？

Hey everyone, I'm building an SSIS project focused on automated reporting, and it's still in the early phases with a limited scope right now. Let me walk through what I've implemented so far:

Dimension Tables #

I've set up two dimension tables pulled directly from our ERP system:

• Customer: A direct copy of the ERP's Customer table—no special change tracking configured here yet.
• Item: Also sourced from the ERP, but this one's set up as a Slow Changing Dimension (SCD). This means it holds a full copy of the current ERP Item records plus historical entries to track how items have changed over time (like price updates or category changes).

Current Workflow Pipeline #

Here's the step-by-step process I've mapped out for the ETL flow:

1. Load Dimension Tables: First, I pull and refresh the Customer and Item dimension tables from the ERP. For the Item table, the SCD component handles detecting changes and retaining historical versions as needed.
2. Load Raw Data Tables: Next, I load three separate raw data tables using the output from three distinct stored procedures. Each proc extracts transactional data that will feed into the final reporting datasets.
3. Insert Audit/Control Record: Finally, I add a single record (still refining the details, but it'll likely be a control entry to log pipeline run status, timestamp, or row counts for auditing and monitoring purposes).

内容的提问来源于stack exchange，提问作者ErpaDerp