How to write Insert statement in ODBC going to SQL target

Jboyd · Post by **Jboyd** » Wed Mar 16, 2011 2:36 pm

I am trying to write a SQL statement into SQL server by using ODBC. I was wondering what kind of format I would write the statement in. Normally Insert into [table] Values [xyz...]. I dont understand how you write that values part since they are coming from the job.

chulett · Post by **chulett** » Wed Mar 16, 2011 3:13 pm

You generally don't need to "write" any SQL, the stage will generate it for you automatically. On the off chance that you really need something user-defined, it's usually best to let the stage generate it for you initially and then you modify it from there. That way you can get an idea what the correct syntax is for the stage in question.

PaulVL · Post by **PaulVL** » Wed Mar 16, 2011 4:53 pm

You've loaded your table definitions from your SQL server right?