SSIS - Transfer data from Multiple tables using a single DFT

Soumya Bhat 0 Reputation points
2023-01-18T09:41:46.0633333+00:00

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

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
729 questions
No comments
{count} votes