In SSIS, I need to store data table values into a SQL Server table using c#, but for my case, I don't want to use SQLBULKCOPY because I need to track the error which row causing an error while insertion. Is it possible to use Linq-to-SQL in SSIS?
Please provide the best method to insert. I am using Visual Studio Data Tools 2017. Target is SQL Server 2016.