Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-08-17 : 01:04:20
|
Hii have created SSIS package for loading SAP data into Staging Area(sql server 2012).i Received below Error in Sql Agent job agent. table : vbak column zexapdat(datatype insqlserver is datetime null) field is showing below error.[ADO NET Source [2]] Error: The error "Input string was not in a correct format." occurred while processing "ADO NET Source.Outputs[ADO NET Source Output].Columns[ZEXAPDAT]".[ADO NET Source [2]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "ADO NET Source"failed because error code 0x80131537 occurred, and the error row disposition on "ADO NET Source.Outputs[ADO NET Source Output].Columns[ZEXAPDAT]" specifies failure on error. An error occurred on the specified object of the specified componentpls help on this |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-18 : 04:37:03
|
whats the source datatype for zexapdat column in SAP database? is it date compatible or string? Also whats the format of values stored in it? Is format consistent always------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-08-21 : 00:31:20
|
[quote]Originally posted by visakh16 whats the source datatype for zexapdat column in SAP database? is it date compatible or string? Also whats the format of values stored in it? Is format consistent always------------------------------------------------------------------------------------------------------ZEXAPDAT column datatype is DATS IN SAP Database and Date value stored in that field and format is consistent.i found one of the record inserted in the that field NULL value. |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-08-21 : 00:31:49
|
ZEXAPDAT column datatype is DATS IN SAP Database and Date value stored in that field and format is consistent.i found one of the record inserted in the that field NULL value. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-21 : 00:46:14
|
can you try applying a transformation to changes NULL to default date value and then try? also whats format in which it stores dates currently?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|