Azure SQL Database
An Azure relational database service.
5,180 questions
On the pre-copy script field, please try to write a query to create the table or objects needed. For example,
Azure Data Factory Copy Activity - Auto table creation in sink side is not applicable for your source dataset
![](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(252.8, 69%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER2%3C/text%3E%3C/svg%3E)
RogerPujolGrau-2941
45
Reputation points
Hi,
ADF throws this error "Auto table creation in sink side is not applicable for your source dataset DummyInput. Please create a new one." when using a SQL Server both as an Input and Output for a simple Copy Activity.
I am trying to replicate SQL tables from a source to a sink, to later make a copy of the data too. But this problem persists even though the type of source and sink is the appropiate one for this functionality. I've also tried to create ADF pipelines to execute a CREATE TABLE statement for each source table but user-defined datatypes and tables are being a problem.
Any approach to make the Auto Create Table work? Couldnt find any similar issue being fixed.
Thanks
{count} votes
-
![](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(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Suba Balaji 11,186 Reputation points2023-05-23T03:20:49.61+00:00 Hello RogerPujolGrau-2941
What is the version of your SQL Server? Is it on prem? Request you to post the source data set details too, as there seems to be something wrong with parameterization of data set (Update the parameters in copy activity)
-
RogerPujolGrau-2941 45 Reputation points
2023-05-23T07:38:24.0066667+00:00 Hello @Suba Balaji , thanks for your answer.
My sql Source server and Sink server versions are 12.0.2000.8. Both are hosted in Azure Portal. The Source Dataset is AdventureWorks.
Properties of Source:
-
Suba Balaji 11,186 Reputation points
2023-05-23T08:32:01.9233333+00:00 Hi, thanks for the details. Can you pls post screenshot of source tab of copy activity?
-
RogerPujolGrau-2941 45 Reputation points
2023-05-23T08:38:05.18+00:00 @Subashri Vasudevan Here it is. Thanks.
-
Suba Balaji 11,186 Reputation points
2023-05-23T14:01:10.6766667+00:00 Everything looks fine to me, let me try to replicate and get back @RogerPujolGrau-2941
-
![](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(220.8, 4%, 31%)' 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)
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee2023-05-24T05:20:38.29+00:00 Hi
RogerPujolGrau-2941 •,Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you are getting error 'Auto table creation in sink side is not applicable for your source dataset' when performing Copy Activity in ADF.
Could you please let us know if the Source and Target is on-premises?
Also, please share some sample data for reference so that we can reproduce the scenario.
Thanks for your support.
-
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee
2023-05-25T09:47:22.6+00:00 Hi
RogerPujolGrau-2941 •,Just checking if you got a chance to look at the previous comment, thanks.
-
RogerPujolGrau-2941 45 Reputation points
2023-05-27T18:29:06.4+00:00 I solved the problem. Seems that Auto Create Table gives an error when the source/sink are SQL Servers. It can be solved by changing the Datasets to SQL Databases. The documentation confused me here:
-
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee
2023-05-29T04:57:43.55+00:00 Hi
RogerPujolGrau-2941 •,Appreciate your efforts in sharing with the community that the problem is solved.
However, we apologize for the documentation confusion. We encourage you to raise your feedback for the document experience at the bottom of the page:
This will help team to enhance document for better user experience. Thank you for your support.
Sign in to comment