User configuration issue copy pipeline

I created a pipeline to migrate a database from Azure SQL Database to Azure SQL Managed Instance.
I followed the steps in this link with few changes : https://learn.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal
ErrorCode=SqlOperationFailed,
'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,
Message=A database operation failed with the following error: 'Invalid
object name 'DBDEV.dbo.User'.',
Source=,''Type=System.Data.SqlClient.SqlException, Message=Invalid
object name 'DBDEV.dbo.User'., Source=.Net SqlClient Data Provider,
SqlErrorNumber=208, Class=16, ErrorCode=-2146232060, State=1,
Errors=[{Class=16, Number=208, State=1, Message=Invalid object name
'DBDEV.dbo.User'.,},],'
the pipeline is working for an existing table but not for the other tables, even if I checked auto create table (see sink screenshot)
that's my precopy script
IF EXISTS (SELECT * FROM DBDEV.[@{item().TABLE_SCHEMA}].[@{item().TABLE_NAME}]) TRUNCATE TABLE DBDEV.[@{item().TABLE_SCHEMA}].[@{item().TABLE_NAME}]
following the INPUT result of the run
{
"source": {
"type": "AzureSqlSource",
"sqlReaderQuery": "SELECT * FROM [db-dev].[dbo].[User]",
"queryTimeout": "02:00:00",
"partitionOption": "None"
},
"sink": {
"type": "SqlMISink",
"preCopyScript": "IF EXISTS (SELECT * FROM DBDEV.[dbo].[User]) TRUNCATE TABLE DBDEV.[dbo].[User]",
"writeBehavior": "insert",
"sqlWriterUseTableLock": true,
"tableOption": "autoCreate"
},
"enableStaging": false,
"translator": {
"type": "TabularTranslator",
"typeConversion": true,
"typeConversionSettings": {
"allowDataTruncation": true,
"treatBooleanAsNumber": false
}
}
thank you for your answer
yes [db-dev] and DBDEV are different databases, the first one in Azure SQL Database and the second in Azure SQL Managed Instance.
I also tested with brackets.
the script works for an existing table but not for the others. (this table was created differently and the truncate works).
It seems that when you parameter dynamically creating different copy, the Auto Create Table does not work. I've found the topic below facing almost same problem.
https://learn.microsoft.com/en-us/answers/questions/65465/copy-activity-failing.html