Yes thanks it worked..

but now I have a separate issue I will open a new post

thanks

folks ! I found a .Net provider executable which I installed and created a provider to MySql database...but now when I create the connection manager I am getting errors...

understood ! now my next question is the flat files are in a directory

and I have to process all the flat files from the directory one by one

how do I...

Thanks Steve for your reply.

Basically there are no specific business rules...customer is sending dates in invalid format and I just need to validate them because SQL Server doesnt accept that..so...