i have stored procedure which returns two results.
CREATE PROC usp_sample
select * from employees
select * from Department
Now i have to export the two results sets data to two csv files with names
employees.csv and department.csv.
How i can achieve this fuctionality using DTS in sqlserver 2000.
Please help me ................