A much more elegant way of doing this without tens of lines of code:

declare @col1 varchar(4096), @col2 varchar(4096)

select @col1 = '', @col2=''

select @col1=@col1 + code + ',',@row2=@row2 + convert(varchar,amount) + ','...

Depending on the number of tables from your Oracle database, this can be really easy or a real chore.

1. At the end of the DTS GUI, you can save your...

Query Analyzer has by default a max limit on the column size at 255.  If you go to Tools -> Options -> Results Tab you'll see a text box for...