SourceInputColumnLineageID自定义属性类型 [英] SourceInputColumnLineageID custom property type

问题描述

您好，我的包执行有问题。当我尝试运行数据转换任务时，我收到以下消息和错误：
$
SourceInputColumnLineageID自定义属性必须是类型VT_I4和Visual Studio错误：VS_ISCORRUPT。

听起来像元数据问题。

包应该从Access文件中提取数据，将其转换并插入SQL Server 2012 Standard实例中的表中。我有以下安装设置：

SQL Server 2012标准

带有商业智能VS 2013的Visual Studio 2013专业版（反过来又为SQL Server 2014安装文件）

我试图卸载SQL和VS并清理注册表。但在安装完所有内容后，问题仍然存在。我的想法是商业智能VS 2013和SQL Server 2012之间缺乏兼容性，但这很奇怪。 

任何人都有类似的问题？

解决方案

我认为您的数据类型未正确映射。在访问中打开数据库，找到问题表，在设计视图屏幕中拍摄并在此处显示。

这是我要找的。

Hello, I have problem with package execution. When I try to run Data Conversion task I get following message and error:
SourceInputColumnLineageID custom property must be type VT_I4 and Visual Studio Error: VS_ISCORRUPT.
Sounds like problem with metadata.

Package should extract data from Access file, convert it and insert into table in SQL Server 2012 Standard instance. I have folowing installation setup:
SQL Server 2012 standard
Visual Studio 2013 Professional with Business Intelligence for VS 2013 (which in turn installs also files for SQL Server 2014)

I tried to uninstall SQL and VS and cleaned the register as well. But after installing everything again problem persists. My thought is a lack of compatibility between Business Intelligence for VS 2013 and SQL Server 2012, but this is weird. 

Anyone had similar problem?

解决方案

I think your datatypes are not mapped correctly. Open up the db in access, locate the problem table, in design view screen shot it and present it here.

Here is what I am looking for.

这篇关于SourceInputColumnLineageID自定义属性类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！