467,915 Members | 1,382 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

A dynamic table to be made into excel file

Hi :

I have a stored procedure which does a crosstab query and builds a
table with differing number of columns and differeing columnnames each
time.
The tablename is static, as i build same table but with differing
columns each time.
Lets call this tableA.
Now i need to get this tableA into an excel file.
So how do i use a dts 2000, to build this excel file ?
I can create a stmt to build an excel file sheet with the tableA
everchanging schema information. But in the data pump task, i
understand that the transformations are predetermined and hence i will
not be able to build a datapump task. Are there any other ways to do
this via a datapump task or something else in sql 2000.

Thank you for all your help
TAAM
Nov 5 '08 #1
  • viewed: 1397
Share:
1 Reply
On Nov 5, 10:08 am, thetaamo...@gmail.com wrote:
Hi :

I have a stored procedure which does a crosstab query and builds a
table with differing number of columns and differeing columnnames each
time.
The tablename is static, as i build same table but with differing
columns each time.
Lets call this tableA.
Now i need to get this tableA into an excel file.
So how do i use a dts 2000, to build this excel file ?
I can create a stmt to build an excel file sheet with the tableA
everchanging schema information. But in the data pump task, i
understand that the transformations are predetermined and hence i will
not be able to build a datapump task. Are there any other ways to do
this via a datapump task or something else in sql 2000.

Thank you for all your help
TAAM
Why not just make your datapump task expect a view with the max number
of columns you'd ever build with anonymously named columns like
column1 through columnmax and then as your new table changes a new
view could also change lining right up with your maxed out view that
your datapump task is attached to?

Thats what I'd do!
Nov 7 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Krzys! | last post: by
3 posts views Thread by josh.kuo | last post: by
1 post views Thread by Jawad Rehman | last post: by
7 posts views Thread by franc sutherland | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.