Pass Schema Name & Table name as a variable in INSERT Query SQL query

Help Studio
1

I have passed the variable (in_DBSchema_Table_Name) dynamically and getting below error

“INSERT Into “+in_DBSchema_Table_Name+” ([DocNo],[Version],[Title],[Language],[FileName],[FileDownloadedDate],[BotStatus],[BotComments]) VALUES (@DocNo,@Version,@Title,@Language,@FileName,@FileDownloadedDate,@BotStatus,@BotComments)”

Error :

image
image978×206 5.85 KB

It works when i hardcode the schema & table name .

Below is the working query :

“INSERT Into [SVC_Test].[dbo].[HMN_CSR__PERFORMANCE_TRACKER] ([DocNo],[Version],[Title],[Language],[FileName],[FileDownloadedDate],[BotStatus],[BotComments]) VALUES (@DocNo,@Version,@Title,@Language,@FileName,@FileDownloadedDate,@BotStatus,@BotComments)”

2

@Sathish_Kumar_S

Try printing the value in locals panel and check if there are any differences to start with

cheers