Now let's find out How do you do it?
There are a few ways to do it but my preferable way to do it by using SQL Task, we mostly use this for generating scripts; however, it can also take the data.
Step 1: Select the database and find generate script option
|Fig 1: Finding out generate scripts for the database|
|Fig 2: Go thought the wizard|
|Fig 3: Choose your database object|
|Fig 4: Advanced scripting options|
|Fig 5: get schema and data together|
You are almost done, after completing the addition few steps in the wizard script will be ready with DDL and data. Now you can move the saved file to the upper environment and run the script, you will find table and data together.