dbTalk Databases Forums  

Export dynamic crosstab to Excel

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


Discuss Export dynamic crosstab to Excel in the microsoft.public.sqlserver.dts forum.



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

Default Export dynamic crosstab to Excel - 02-06-2004 , 10:54 AM






Hi All,
A few days ago I posted a similar message, and it solved
half of my problem. And now the other half.
I created an DTS to export a dynamic crosstab (number of
column is vary every day) to Excel. Unfortunately, the
destination and data structure of the excel file need to
declare beforehand in DTS. And this is not possible in my
situation when the number of columns vary frequently.
Has anyone try to do DTS for dynamic crosstab to Excel
before? Any assistant would be greatly appreciated,
Culam

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.