I have a Insert Activity to a SQL Database. The insert works fine except for on field. The field is defined inthe data base as <email address>. Yes it has the space in it.
When I do the insert it throws a sql error. Is there a way to force the brackets are around the coulmn name email address so that the insert won't fail.
SystemAdmin 110000D4XK1250 Posts
1.Go To SQL Endpoint2010-07-29T18:47:55ZThis is the accepted answer. This is the accepted answer.1.Go To SQL Endpoint settings
2. Check "Quoted Identifiers for tables, columns and objects with quotes.
4. Try to insert the data.
This solutions works specially if you have spaces in SQL field names.
JohnCroson 270000PXQN4 Posts
Re: 1.Go To SQL Endpoint2012-06-11T18:21:42ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
SQLSTATE: HY000 ERRORCODE: 102 Error Message: [CastIron Systems][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '-'.