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

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

Pooja Chowdhury · 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