3

enter image description here

I am doing SSIS Error Handling. In excel file source have four columns id,name,department,salary. Id and salary (integer column are fine detect varchar datatype and redirect into bad data entry) but name and department(varchar column consider integer and string both values in good data table)?

We want redirect integer values from name and department column to bad data entry

In data conversion transformation configure error output tab to "Redirect" all four rows.Integer datatype (Id and Salary) working fine throw var-char value into bad data table but Va-char datatype column (Name and department) do not throw integer value into bad data table .

enter image description here

Could any one please help me this issue?

enter image description here

Hadi
  • 36,233
  • 13
  • 65
  • 124
Ankush
  • 347
  • 2
  • 10

1 Answers1

1

Open the Data Conversion Transformation editor, Go to Configure Error Output and set the error handling option to Redirect Row.

For more information, you can refer to the following articles:

Update 1

If you are looking to extract numeric values from varchar column you must use a derived column to check if it conatins numeric value and redirect row based on result:

Example

(DT_I8)[Name] == (DT_I8)[Name] ? NULL(DT_WSTR,50) : [Name]

The error output will contains non numeric values. The main output will contains numbers.

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • Thanks for replying.But i have all ready configured Data conversion error output tab to 'Redirect" for all four rows.Integer column(Id and Salary) are working fine they throw all var-char value into bad data table and integer value into good data table but Var-char Column(Name and department) do not throw any integer value to bad data table...all data goes to good data table.....Hope so i have expained the issue – Ankush May 16 '19 at 10:05
  • @Ankush feel free to mark this answer as accepted by clicking on the mark on the left side of the answer – Hadi May 17 '19 at 16:01
  • Marked as useful and resolved problem @Hadi...once again thanks a lot. – Ankush May 20 '19 at 11:28