September 7, 2016 at 7:34 am
Hi,
I have a SQL Server 2008 in Server 1 , where I have a job of loading flat file in Table.
the flat file which is a zip is located in server 2 the SSIS package unzip, check if the header contains all fields then load it in database table.
I noticed that the load is not complete, when I open my logfile I found errorcode = -1071607689
and errorcolumn = 883 ,
the rejected lines are dates for example
31-Oct-16
13-May-05
but it accepts for example
31-SEP-13
I have to open file to change date to german and to run the job ... it's weired, I tried to force my languages to english in my 2 servers but no luck...
I googled and I found the description of the error code : The data value cannot be converted for reasons other than sign mismatch or data overflow.
but I can't understand this message
please Help.
September 7, 2016 at 10:13 am
benkraiemchedlia (9/7/2016)
Hi,I have a SQL Server 2008 in Server 1 , where I have a job of loading flat file in Table.
the flat file which is a zip is located in server 2 the SSIS package unzip, check if the header contains all fields then load it in database table.
I noticed that the load is not complete, when I open my logfile I found errorcode = -1071607689
and errorcolumn = 883 ,
the rejected lines are dates for example
31-Oct-16
13-May-05
but it accepts for example
31-SEP-13
I have to open file to change date to german and to run the job ... it's weired, I tried to force my languages to english in my 2 servers but no luck...
I googled and I found the description of the error code : The data value cannot be converted for reasons other than sign mismatch or data overflow.
but I can't understand this message
please Help.
In my experience I have found that files sometimes are read as different data types, these can be easily seen by placing a Data Conversion step between your input file and your destination database. What you think is a datetime value might be seen in SSIS as NTEXT because of underlying formatting that you cannot see by simply opening the file and reading it.
You can also write the failed output lines to a separate file and process them manually if they are few enough.
Without knowing more about your input file though, I can only offer generalities....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply