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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export Multiple .csv files using DTS
- Thread starter Deam
- Start date
- Thread starter
- #2
akalinowski
IS-IT--Management
in SQL 2005 its now called SSIS
simply right click on the database in management studio and then go to export data, run through the steps near the end you have the option to save the package as well as execute it. save it some where that the server can always access it (I made a folder under C:\ called SSIS for these packages) and then make a job for it, the jobs menu can also be found in the management studio, schedule the job as often as you like and there you go.
akalinowski
MCSE 2000, A+, N+, LCP, CNE
simply right click on the database in management studio and then go to export data, run through the steps near the end you have the option to save the package as well as execute it. save it some where that the server can always access it (I made a folder under C:\ called SSIS for these packages) and then make a job for it, the jobs menu can also be found in the management studio, schedule the job as often as you like and there you go.
akalinowski
MCSE 2000, A+, N+, LCP, CNE
- Status
Similar threads
- Locked
- Question
