Output special chars for beg / end row qualifiers of csv file 1

[benaround]

In using DTS to output a table as a comma seperated set of fields, I have used the normal Import/Export wizzard.

For a sepecial case, I have to have a open bracket, {, and a close bracket, }, as the beginning and ending of a row / record for a text file.

I have looked at the VB code and have tried to navigate changes to have this work properly, but to no avail.

Thanks for any help ahead of time.

 

[JayKusch]

You need to modify your SELECT statement that is exporting the table to the CSV file. Hopefully, the first and last columns will be of a VarChar/Char variety.

If so for example, Field1 and Field10 are defined as VarChar(20), we could ...

Modify your SELECT Statement to be somthing like this...

SELECT '{' + Field1, Field2, Field3, ... Field10 + '}'

IF your first and/or last fields in the SELECT are not of the VacChar/Char variety ... you may want to order the fields that you are selecting to have the first and last fields as character types.

Thanks

J. Kusch