dbTalk Databases Forums  

DTS to Excel

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS to Excel in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mark Paulson
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.