String Conversion - SqlServer Target ODBC

[WarehouseMan]

Hello All,

I currently have a DStage job that simply reads a flat file and inserts the data into an SQLServer database, via an ODBC Stage. The problem that I am having is that SQLSever expects all string datatype values to be enclosed with single quotes (').....while DStage, by default, encloses all string values with double quotes (") when inserting into a table.

The question is how, if at all possible, can I specify in DStage to use single quotes instead of double quotes?

Your response will be greatly appreciated.

HAPPY HOLIDAYS!!!!!

[DSguru2B]

Welcome Aboard
By specifying (') in the quote character box in seqential file stage properties.

[chulett]

Welcome Aboard, matey! :D

Did you try clicking on the 'Get SQLInfo' button on the General tab of the ODBC stage? That should query the database and set that option automatically for you based on what it finds the target needs.

Failing that, you should be able to manually change the Quote character there to a single quote, I would think.

[chulett]

By specifying (') in the quote character box in seqential file stage properties.

Bzzzt... thanks for playing! Was an ODBC question, my friend, not a flat file question.

[DSguru2B]

Either way, now he has both the answers. Can work/play with both the options

[ray.wurlod]

Is it really a single quote, or a back tick ( ` )? Anyway clicking the GetSQLInfo button in the ODBC stage will load the correct character and, as a useful side effect, prove connectivity to the data source. Error-free (silent) execution equals good connection.