刷新Integration Services中的目标架构元数据 [英] Refresh destination schema metadata in Integration Services

问题描述

我一直在进行一个庞大的ETL项目，其中包含150多个表，在设计期间，我不得不对几个表的目标列名和数据类型进行重大更改.

我的问题是我无法让SSIS看到更改过的表的新架构.因此，我想知道如何使SSIS刷新此架构?我觉得有点荒谬的是，没有办法告诉SSIS更新数据库架构中的元数据，尤其是对于数据库迁移. /p>

重新创建项目是没有问题的，因为我已经花了几个小时了.也不能手动更改我更改的400多个列.

解决方案

在我之前的自动回答之后，我终于发现阻止元数据刷新的原因.

当我最初修改数据库时，实际上执行了另一个脚本，该脚本在表上创建DROP，然后在CREATE TABLE上重新创建表.在那里，SSIS永远都无法检测到变化，我不得不做其他回答中的所有事情.

今天晚些时候我必须进行一些小的修改，这次我选择了ALTER TABLE.神奇的是，这次SSIS检测到所有更改，甚至通知我从高级编辑器刷新列，效果很好.

因此，基本上所有这些问题都是由于我对DBA及其最佳实践的了解不足所致.

I have been working on a huge ETL project with 150+ tables and during the design I had to make a major change on destination column names and data types for a couple of tables.

My problem is that I can't get SSIS to see the new schema for the tables I changed. So I would like to know how can I get SSIS to refresh this schema? I find it kind of ridiculous that there no way to tell SSIS to update the metadata from database schema, especially for database migration.

Recreating the project from scratch is out of question because I already spent some hours on it. Also changing manually the 400+ columns I changed is also not an option.

解决方案

Following my previous auto-answer, I finally found what was preventing the metadata from being refreshed.

When I originally modified my database, I actually executed another script that was making a DROP on the table and then a CREATE TABLE to recreate the table from scratch. There, SSIS was never able to detect changes and I had to do all the things in my other answer.

Later today I had to make some minor modification and this time I opted for an ALTER TABLE. Magically, this time SSIS detected all the changes even notifying me to refresh columns from the advanced editor, which worked fine.

So basically all these issues has been caused by my poor knowledge about DBA and its best practices.

这篇关于刷新Integration Services中的目标架构元数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！