Hi,
Your suggestions are always welcome. No body responded for this one yesterday that's why I deleted it.
I have kept it for halfen hour and taken back. Now I am keeping again and will not delete it.
In the execute SQL task nothing is there. I have given only
EXEC sp_TransferIH
Thank You