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 |
|
duncanpts
Starting Member
11 Posts |
 Posted - 2013-05-14 : 00:35:38
|
| After successfully deploying my SSIS package, the job in SQL Server was failed. Apparently this is something to do with SSIS data flows connecting to my database but I can't figure what's wrong. The error code from the log file is below.I would appreciate any suggestions.errror msg:[table_A Source [2]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07.An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80040E07 Description: " CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007".[SSIS.Pipeline] Error: table_A Source failed the pre-execute phase and returned error code 0xC0202009. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-14 : 00:53:27
|
| The problem seems in date values coming in a field. SSIS couldnt interpret date from it. Seems like DB2 server connection is the culprit. Check the query you use to pull data from DB2------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
duncanpts
Starting Member
11 Posts |
Posted - 2013-05-14 : 02:04:44
|
| starting i have put variable to select the date, failed. "select * from table_A where Create_date >?"after i try normal query also cannot. " select * from table_A". |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-14 : 02:12:53
|
| check the date related fields in table_A and also value coming to see if its in valid format------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
duncanpts
Starting Member
11 Posts |
Posted - 2013-05-14 : 02:20:53
|
| some is null, how to handle it?thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-14 : 02:39:22
|
| add a function to convert those NULLs to valid date value. You can do it either inside source query using DB2 functions (I'm not faimilar with DB2 so you need to serach it out). You may also chose to do it in SSIS using derived column task.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SSIS job failed to connect to database