August 28, 2008 05:27pm pdt

1. chapmandew 115,410
2. acperkins 65,629
3. nmcdermaid 54,964
4. cs97jjm3 33,643
5. brejk 30,000
6. PedroCGD 27,580
7. angelIII 25,710
8. frankytee 24,691
9. mark_wills 22,185
10. dready 18,000
11. EugeneZ 16,950
12. bhess1 15,550
13. Zberteoc 13,050
14. matthews... 12,250
14. rickchild 12,250
16. JimFive 8,375
17. MohammedU 8,325
18. aneeshatti... 7,802
19. momi_sa... 7,750
20. dbbishop 7,300
21. pratima_... 7,150
22. ptjcb 7,120
23. paulop1... 7,100
24. dbaSQL 6,065
25. dportas 6,000

1. acperkins 333,878
2. nmcdermaid 167,681
3. angelIII 166,126
4. arbert 149,684
5. chapmandew 115,410
6. EugeneZ 67,768
7. matthews... 50,304
8. aneeshatti... 41,799
9. cs97jjm3 40,173
10. ptjcb 38,638
11. rboyd56 37,425
12. bhess1 35,130
13. brejk 30,000
14. PedroCGD 29,080
15. dready 28,430
16. Sirees 27,902
17. twoboats 27,515
18. frankytee 27,441
19. jltoops 27,275
20. Yveau 25,800
21. TommyTupa 23,000
22. Lowfatsp... 22,395
23. mark_wills 22,185
24. Kevin3NF 20,630
25. imran_fast 20,539

05.05.2008 at 08:47AM PDT, ID: 23376738

	[x] Attachment Details

Export Multiple Tables to Multiple Text Files as a scheduled task

Asked by jimshock in MS SQL DTS

Tags: Microsoft, SQL Server 2000, 2000

I need to develop a way to export specific tables out a SQL Server database into multiple text files (one for each table) and to be able to set this as a scheduled task. I know we can export into one big text file but this won't do; we'll be uploading these files nightly to a web server. Anyone have any thoughts as to how to do this?Start Free Trial

Keywords: Export Multiple Tables to Multiple Text Fi…

	Title
1	Scheduling an Agent - Not Working
2	SOAP and DTS? How to schedule we…
3	Export SQL to text file through Code
4	Scheduled Tasks will not start or run.
5	ASP Scheduler
6	Export these data from ADS

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Export Multiple Tables to Multiple Text Files as a scheduled task

Asked by jimshock in MS SQL DTS

Tags: Microsoft, SQL Server 2000, 2000

About this solution