Excel data to sql database

Help Activities
1

image
image1192×871 57.4 KB

Hi,

I am getting error in insert syntax error, how to resolve it, Please help.
Sequence fem.zip (2.9 KB)

Thanks,
Lakshmi

2

Show your connection settings in the activity’s properties.

3

image
image1338×762 39.6 KB

4

Show your connection settings. They aren’t in this activity. They’re in another activity and being stored in Db_Connection.

5

Database connection is correct but i am getting error in insert syntax. I have attached workflow, please look on it

6

Unfortunately I can’t download things like that, I’m not allowed.

I guess the only advice I can offer is to try to figure out where there is a / occurring. That’s what it’s complaining about. Maybe in one of your column names?

7

In general we would recommend to go for more standard column name conventions and trying to avoid spaces / … in column names.

In case there is noch chance to adopt the column names give try on double / the / in the column name for escaping

Aircraft S/N to Aircraft S//N
Some database can be handled when [ColName WithSpace] the col name

Which DBMS is in use?

8

Hi,

I am using sql management studio

Regards,
lakshmi