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!!