DTS to Excel -
07-26-2006
, 06:20 PM
Hi All,
I'm using a Data Driven Query task to export SQL data to Excel. I have it
working fine except I can't figure out how to control the "data type" of the
columns in the Excel sheet. On the Bindings tab on the Data Driven Query task
every field is listed as VarChar(255). However, when I created the Binding
table in the Excel doc via the Create button on this tab there were the
correct data types for each field. Is there a way to change the Type of the
binding columns? Or is there some other solution?
Thanks, Mark |