Sorry, I just overlooked the link. I was under that impression that it's your signature!

Thanks for quick reply.

Thanks,

Yash

Thanks for the reply. Where can I find the Adapter for Oracle?

Thanks

Yash

I was the one who created the SSIS package and now learning to customize it by rollover at the fail condition and send email the results. I will definitely look...

I am little families with BIDS, do you have any instruction/step by step guide for this?

Thanks,

Yash

Thanks John for the quick reply, I am guessing that's on the Job Scheduler at the SQL agent area?

Yash

Thanks for your input. I looked at the table and found few corrupted data in wrong format. I exclude those and now I am able to import data into the...

It's mdy for English. How can I change to mm/dd/yyyy? Where?

Thanks,

Could you please tell me where can I see for that setting?

Thanks,

Yash

I found couple of data that are in wrong format 1/1/0001 (old data) so I have modified the sql to look for the date that are good, but still I...

Yes.

I am using default settings of the SSIS Package utility.

Thanks,

Yash

Perfect, this saved me lot of time and energy. Much Appreciated.

Thanks,

Yash