SSIS flat file null rows as Error output

Question

Hi,

I have a flat file with some data. I want to take the null rows(Any data may be null) to another error table . how can i do it?

Answer 1

Hi,

You can use conditional split component in transformation in you SSIS package.

I hope this is helpful.

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid

MyBlog

Answer 2

Hello,

Follow the below thread with the same issue. It will help you.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f21a52ca-b717-469b-9f13-37d3ad3b12ce