Hi

I have adts pkg executes a simple query from a tbl it returns an integer and a varchar field and stores the result set in an xls file. First time when I created the pkg it creates the result set correct in xls file. I deleted the resulted rows in xls file and saved the file and ran the pkg again and when I opened the xls file it created a single quote in front of the integer column. I have used activex transformation to convert the intfield value to cint(destvalue). But it won't work. Any help would be appreciated

Aruna

After first run the pkg changes the destination field type to varchar(255). Is there a way to retain the old settings, i.e int type for the xls tbl field

Thanks