it seems you are inserting to SQL Server table with datetime column.
check the format of the date you are inserting, i think it should be yyyy-mm-dd .......
Indeed SQL Server understands a whole lot of different date/time formats (and many of them are "localised", meaning that the exact format depends on the country you work in).
So chances are good that you feed some unusable format into a Date/Time value if you feed it via a string instead of with a Date/Time port in PowerCenter / ICS / IICS.
Could you please check whether the port you're feeding to SQL Server is a String port or a Date/Time port in your mapping?
If it is a string port in the mapping, then you should explicitly translate it to a Date/Time port using the TO_DATE() function, then you can safely forward this Date/Time port to SQL Server.
Everything else can get you into serious trouble (as you already found out).
Thank you dear for your help, I managed to identify the error, and this was that there were records with dates lower than those supported by SQL SERVER, so I put a mask to enter the table and the process was executed, thanks