Getting error in insert activity as incorrect syntax near keyword ‘File’.
Share your insert query here
Could you please share the query where you have used “File” keyword.
I am not using any query here… i am using insert activity here.
RegardsMain.xaml (10.5 KB)
This is my .xaml file.
Show us the Properties Tab for Insert activity
I have share the xaml file .
Could you please check the below things?
- make sure columns names are same as the column names of your table.
- your data or column names should not have any ’ or "
I have removed all and or _ keywords from columns name
above are my .Xaml and excel file. I already created table in database. I am using same table name in insert activity.
could you please share screenshot of your sql table column names?
These are my columns mentioned in notepad.SqlColumns.txt (480 Bytes)
Thanks @Gauri_Rawool for sharing the column names.
you can try it as below.
Read you sql table = dtSqlTable
read excel = dtYourExcelRead
and then insert dtYourExcelRead as it is in the sql table.
hope this will work for you.
how i read my sql table?
how many assign activity i should use?
Just on select * from query to read entire SQL table.
Inside while as I mentioned above, there would be only one assign activity like…
And make sure to increment i=I+1
ok…thanks a lot
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.