SSIS程序包中的数据流任务失败 [英] Data Flow Task fails in SSIS Package

问题描述

朋友，
我是SSIS的新手，使用SSIS中的数据流任务将数据从平面文件加载到SQL 2005表时遇到了问题.

SQL表具有带有DEFAULT绑定的列，当我删除所有列的那些DEFAULT绑定时，数据流任务将获得成功，并且表中将加载数据.
但是使用默认绑定，该任务将失败，并且该表不会使用数据生成.

请帮助我解决问题的可能原因.
预先感谢，
问候，
Suresh Kumar.B

Hi Friends,
I am new to SSIS and I am facing an issue while loading data from a Flat-File to SQL 2005 table using Data Flow Task in SSIS.

The SQL table has columns with, DEFAULT Bindings, when i remove those DEFAULT Bindings for all the columns, the Data Flow Task is getting success and the Table is loaded with data.
But with the Default Bindings, the task fails and the Table is not generted with data.

Please help me on what could be the cause of the issue.

Thanks in advance,
Regards,
Suresh Kumar.B

推荐答案

查看此链接可能会对您有所帮助
http://www.bigresource.com/MS_SQL-Calling-SSIS- package-from-C-code-tLe6Qy7b.html [ ^ ]

see this link it may help u
http://www.bigresource.com/MS_SQL-Calling-SSIS-package-from-C-code-tLe6Qy7b.html[^]

有很多可能性.
1)检查您的列分隔符与数据中的不相同
2)列映射问题

there are many possibilities.
1)check your column deliminator not the same as in data
2)problem with column mapping

这篇关于SSIS程序包中的数据流任务失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！