0

I am importing CSV files from a folder which is generated by another application. While importing using SSIS package in some CSV files instead of date format decimal value are coming how to skip such values while processing in Derived column to avoid error.

Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
manu vijay
  • 367
  • 3
  • 13

1 Answers1

0

Use the error output of the Derived column transformation to redirect such rows to either a flat file or a table of your choice.

rvphx
  • 2,324
  • 6
  • 40
  • 69