If you want to create a cplumn that has more than 255 characters, you can use TEXT as its datatype (not sure if it works for more that 8000 Characters).

For...

thanks. I am new to SSIs , could you please explain it.

also,can anyone let me know how to execute this SSIs package thru vB 6 or VB.net

Thanks

Thanks. I really appreciate your solution. I am new to SSIS. suppose, if I add a table with Dayname and Recepients, how could I fetch them and put them in...

I cannot add table since database is in the production environment.