Auto create table error in copy activity for sql to sql pipeline

Question

Hi,

I'm getting an error trying to preview data in the sink process. I selected the auto create table option for the source data which should automatically create a table in my sink sql datawarehouse but its not. Here's the error I get when trying to preview the sink data.

A database operation failed with the following error: 'Invalid object name 'dbo.QRScanInfo'.' Invalid object name 'dbo.QRScanInfo'., SqlErrorNumber=208,Class=16,State=1, . Activity ID: a498c17c-1914-4567-b1ce-fb29c3531092

Here is a screenshot of the connection details.

Answer 1

Hi @Brighter Bites ,

Welcome to Microsoft Q&A Platform.

Copy activity creates the table automatically if Sink settings of "Auto Create table" is selected after the pipeline is executed. Since the dataset can be input/output, the "Preview data" option is enabled for it. Please check "Preview data" after execution of pipeline and data should be visible.

Hope this helps! Please let us know for further queries and we will be glad to assist.

Answer 2

Please try to run the pipeline. After pipeline execution, ideally it should create a table before loading the data at Sink.

Maybe then only you will be able to preview the Sink table data in Dataset.

===============================================
If the response helped, do "Accept Answer" and upvote it -- Vaibhav