Page 1 of 1
How to write Insert statement in ODBC going to SQL target
Posted: Wed Mar 16, 2011 2:36 pm
by Jboyd
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.
Posted: Wed Mar 16, 2011 3:13 pm
by chulett
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.
Posted: Wed Mar 16, 2011 4:53 pm
by PaulVL
You've loaded your table definitions from your SQL server right?