Hi @SQLLover21 ,
I need to extract that table with the schema and the data from the PROD server to DEV server.
We can use the following two methods in SSIS package:
1.We can use OLEDB Source and OLEDB Destination in Data Flow Task .
2.We also can use Transfer SQL Server Objects Task in Control Flow .
Please refer to the following pictures:
Method 1:
Method 2:
Results:
Best Regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.