Incorrect syntax error in insert activity

Help
, ,
1

error
error1024×768 53.1 KB

Getting error in insert activity as incorrect syntax near keyword ‘File’.

2

@Gauri_Rawool,

Share your insert query here

3

Hi,

Could you please share the query where you have used “File” keyword.

Regards,
AK

4

hii @AnandKumar26

I am not using any query here… i am using insert activity here.

RegardsMain.xaml (10.5 KB)

This is my .xaml file.

5

Show us the Properties Tab for Insert activity

Regards,
AK

6

I have share the xaml file .

7

Hi @Gauri_Rawool
Could you please check the below things?

  1. make sure columns names are same as the column names of your table.
  2. your data or column names should not have any ’ or "

Thanks!

8

hii @Deepak94

I have removed all and or _ keywords from columns name

9

Feed Files Trackers.xlsx (14.8 KB) Main.xaml (10.5 KB)

above are my .Xaml and excel file. I already created table in database. I am using same table name in insert activity.

11

Hi @Gauri_Rawool,
could you please share screenshot of your sql table column names?

Thanks!

12

These are my columns mentioned in notepad.SqlColumns.txt (480 Bytes)

13

Thanks @Gauri_Rawool for sharing the column names.
you can try it as below.
Read you sql table = dtSqlTable
read excel = dtYourExcelRead

assign i=0
while i<dtYourExcelRead.column.count
assign dtYourExcelRead.column(i).ColumnName=dtSqlTable.column(i).ColumnName
i=i+1

and then insert dtYourExcelRead as it is in the sql table.

hope this will work for you.
Thanks!

14

how i read my sql table?

15

how many assign activity i should use?

16

Hi @Gauri_Rawool,
Just on select * from query to read entire SQL table.

Inside while as I mentioned above, there would be only one assign activity like…
dtYourExcelRead.column(i).ColumnName=dtSqlTable.column(i).ColumnName

And make sure to increment i=I+1

Thanks!

17

ok…thanks a lot

1 Like
18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.