SSIS - Transfer data from Multiple tables using a single DFT

Soumya Bhat 5 Reputation points


I followed all the procedures in this post and created a SSIS Package. (

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.
846 questions
{count} vote