how to send SSIS redirected error rows to json/nvarchar column in sql sever table
I have SSDT transformation component where I have configured in case any truncation, send them to SQL server table. requirement is to capture error information, error code and other column info in json format. I know this can be achieved using script component, but looking for any code snippet.
I have SSDT transformation component where I have configured in case any truncation, send them to SQL server table. requirement is to capture error information, error code and other column info in json format. I know this can be achieved using script component, but looking for any code snippet. Read More
