SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Sql Agent job Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kond.mohan
Posting Yak Master

India
185 Posts

Posted - 08/17/2013 :  01:04:20  Show Profile  Reply with Quote
Hi

i 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 component

pls help on this

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 08/18/2013 :  04:37:03  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

kond.mohan
Posting Yak Master

India
185 Posts

Posted - 08/21/2013 :  00:31:20  Show Profile  Reply with Quote
[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.
Go to Top of Page

kond.mohan
Posting Yak Master

India
185 Posts

Posted - 08/21/2013 :  00:31:49  Show Profile  Reply with Quote

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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 08/21/2013 :  00:46:14  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000