Hi,

I need to export from couple table data to a csv file.
But I don't know how to do the following.

The table will, OrderID, no of item, item no, qualtity description.
5020023, 2 , 1 , 1 , Cable
5020023, 2 , 2 , 5 , T
Connector

and the output file need to add 1 to the no of item and item no, and add
("sales tax" into descrption to each order. How can I do it?
The table will be, OrderID, no of item, item no and qualtity, description.
5020023, 3 ,0 ,0 , Sales
Tax
5020023, 3 , 1 , 1 , Cable
5020023, 3 , 2 , 5 , T
Connector

Thanks,

Dannie

So you want to add 1 to each number of items abd add a constant value of
"Sales Tax" to each order

You can use

[Item no] + 1 as ItemNo

AND

'Sales Tax' as SalesTax


Add these to the SourceSQLStatement (You will need to type the select
not choose from the dropdown list of tables)

If this is not what you want then come back with more info.

Allan

"Dannie Chan" <DannieChan (AT) discussions (DOT) microsoft.com> wrote