Hello Experts Exchange
I have a SSIS package that fails every once in a while with the following error message.
The value could not be converted because of a potential loss of data.
I want to push data like this to a flat file and that the SSIS package will continue and finish with suggest.
The data is coming from a Excel spread sheet and I save the data into a SQL Server database.
Can you provide step by step instructions on how I can reconfigure the SSIS package to push bad rows into a flat file please?
Thank you for reading.