SSIS - Transfer data from Multiple tables using a single DFT

Hi...

I followed all the procedures in this post and created a SSIS Package. (https://social.technet.microsoft.com/wiki/contents/articles/33564.ssis-transfer-data-from-multiple-tables-using-a-single-dft.aspx

When i tried to execute this package all the task under this package is executing successfully. But the data's are not loaded in to the destination table as required.

When i tried to debug the package i found that the data is getting loaded to the "Staging Table" but from Staging Table it is not getting loaded to the Destination table.

So i tried to trigger the stored procedure (RefreshTable_Insert) manually but it is returning "0" values.

Can anyone help me on this to get resolved.....

Thanks in advance!!