ssis:导数据双击时出现下面这个报错,不知道怎么解决,困扰一天了,百度论坛各种搜,没找到解决方法,新人刚接触,请各位帮忙,感谢!!
截图如下:
![](https://img-my.csdn.net/uploads/201301/10/1357831983_7857.jpg)
文字处内容:
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时 弹出对话框如下,
![](https://img-my.csdn.net/uploads/201301/10/1357832952_4266.jpg)
文字内容如下:
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为空,换其他表同样的错误。
截图如下:
![](https://img-my.csdn.net/uploads/201301/10/1357831983_7857.jpg)
文字处内容:
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时 弹出对话框如下,
![](https://img-my.csdn.net/uploads/201301/10/1357832952_4266.jpg)
文字内容如下:
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为空,换其他表同样的错误。
这是还没关联,在双击flat file 前一定要先拉出箭头!新手要特别注意这点!