copy table data from one table to another table using ssis

Question

how to copy table data from one table to another table using ssis package what is the step

aiswarjya sarengi · Answer

can i use PGAdmin for destination table

Nilesh Patil · Answer

Hi Refer below links http://www.c-sharpcorner.com/blogs/insert-data-from-one-table-to-another-table-using-ssis1 https://stackoverflow.com/questions/20063225/ssis-how-to-copy-data-of-one-table-into-different-tables

Rajeesh Menoth · Answer

Hi Answer for Ram in Stack. Just briefing Create a SSIS Package. Which flows like follow Take Data Flow Task Take OLE DB Source and point to Your source table. Keep one lookup to restrict already loaded records.(If you execute multiple times) Take a OLE DB Destination and point to parent table. Take one more Data flow task and point to your source table. keep lookup to get ParentTable ID Keep one lookup to restrict already loaded records.(If you execute multiple times) Take OLE DB for 3 child tables and Load into your child tables. Please ref the following link : https://stackoverflow.com/questions/20063225/ssis-how-to-copy-data-of-one-table-into-different-tables