在ssis中插入数据期间发生了异常 [英] An exception has occurred during data insertion in ssis
问题描述
在Excel文件中,例如OrigLoanAmt列在create table脚本中包含值为0.00&added列,如下所示:
创建表SampleLoans
(
[OrigLoanAmt] [decimal](18,0)NOT NULL,
)
使用列OrigLoanAmt的数据转换转换编辑器使用数据类型作为双精度浮点[DT_R8]。
但是在激活ssis包时出现错误:
[ADO NET目标[3749]]错误:数据插入期间发生异常,从提供程序返回的消息是:列''OrigLoanAmt''不允许DBNull.Value。
In Excel file e.g. OrigLoanAmt column contain value as 0.00 & added column in create table scripts as below:
Create table SampleLoans
(
[OrigLoanAmt] [decimal](18, 0) NOT NULL,
)
Using data conversion transformation editor for column OrigLoanAmt used data type as double -precision float[DT_R8].
But while excuting ssis package belwo error occure:
[ADO NET Destination [3749]] Error: An exception has occurred during data insertion, the message returned from the provider is: Column ''OrigLoanAmt'' does not allow DBNull.Value.
推荐答案
在create语句列中不允许null如下所示
[OrigLoanAmt] [decimal](18,0)NOT NULL,
将其更改为允许为空。
In create statement column is not allowing null as below
[OrigLoanAmt] [decimal](18, 0) NOT NULL,
Change it to allow null.
这篇关于在ssis中插入数据期间发生了异常的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!