求教:ssis数据迁移时报错:Validation error
ssis:导数据双击时出现下面这个报错,不知道怎么解决,困扰一天了,百度论坛各种搜,没找到解决方法,新人刚接触,请各位帮忙,感谢!!
截图如下:
文字处内容:
Error 1 Validation error. Data Flow Task: Data Flow Task: A connection manager has not been assigned to the runtime connection "FlatFileConnection" (18). Package2.dtsx 0 0
Error 2 Validation error. Data Flow Task: Data Flow Task: A connection manager has not been assigned to the runtime connection "FlatFileConnection" (18). Package2.dtsx 0 0
详细说明:
1、双击 flat file destination时 弹出对话框如下,
文字内容如下:
TITLE: Microsoft Visual Studio
------------------------------
This component has no available input columns.
Do you want to continue editing the available properties of this component?
------------------------------
BUTTONS:
&Yes
&No
------------------------------
2、点击yes,往下操作后,到column处显示column为空,换其他表同样的错误。
这个问题该怎么解决,恳请前辈指教!!谢!!
ssis
validation
bi
FlatFileConnection
------解决方案--------------------楼主问问题很给力啊,详细,还配图。
找个人给分结贴,或者无满意答案结贴,不过那样就没法返回一半分数了。