Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Dynamic Table

Status
Not open for further replies.
dpgirl

dpgirl

Technical User
Apr 5, 2005
45
0
0
US
I have a cross-tab SQL function that is dynamic -- the number of rows and columns can vary each time I run it. Is there a way to output the results to an excel or csv/txt file through DTS given the dynamic rows & columns?
 
Status
Not open for further replies.

Similar threads

smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
125
markjoseph1232
markjoseph1232
swhitten
  • Locked
  • Question
Writing view to table - fastest/easiest way?
Replies
2
Views
29
swhitten
swhitten
kristal9
  • Locked
  • Question
External Table Not in Expected Format 1
Replies
4
Views
69
drlex
drlex
Lost500
  • Locked
  • Question
add uniqueidentifier field to existing table
Replies
1
Views
36
mutley1
mutley1
smedvid
  • Locked
  • Question
Suggested Design for Multi-File Export to Tab Delimited ...
Replies
1
Views
32
AlexCuse
AlexCuse

Part and Inventory Search

Sponsor

Back
Top