How to write Insert statement in ODBC going to SQL target
Moderators: chulett, rschirm, roy
How to write Insert statement in ODBC going to SQL target
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers