This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 36%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
HI,
I have a demo environment for Azure Data Factory, I have setup pipeline to copy some tabled from my on-perm SQL server to an Azure SQL server. When trigger the pipeline on-perm tables get copied to the Azure DB.
Now I have to copy more tables from the same on-perm DB to the same SQL SQL Azure DB.
I did create a new data set in existing pipelines, now I see the original dataset with 4 tables and destination dataset and the newly added dataset for the new table, after triggered the pipeline I can see that only the tables from the first dataset get copied to the Azure and the newly added table is not get copied.
Any suggestion on how to add extra tables to existing pipeline?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hello @Shahin Mortazave ,
We haven’t heard from you on the last response from @Nandan Hegde and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Hello @Shahin Mortazave ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Hey @Shahin Mortazave
Can you please share the image and json code of your pipeline
Based on whatever data you have provided, it seems that you have created new datasets but you have not created new copy activity in the pipeline to map the data sets
@Nandan Hegde Thank you for your reply,
I agree with you, I have just create a new dataset and have no idea how to put this dataset in copy activity, should I create the dataset by editing the copy activity?
These are some screenshots from my demo ADF:
Hey ,
Sorry to have missed out on this.
There are multiple ways to create a dataset : either you can create dataset while setting up the copy activity or you get an option to create a new dataset as below:
Also you can have multiple copy activities within a single pipeline.
So once you have created the datasets, then create a copy activity for each table and map the already created datasets in the copy activities.