Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple extracts using DTS Expand / Collapse
Author
Message
Posted Friday, May 4, 2012 12:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 29, 2014 6:44 AM
Points: 74, Visits: 260
i have stored procedure which returns two results.

CREATE PROC usp_sample
AS

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 ................
Post #1295062
Posted Monday, May 7, 2012 12:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 29, 2014 6:44 AM
Points: 74, Visits: 260
Can anyone please help me hoe can i achieve this functionality.
Quicker responses are appreciated..
Post #1295805
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse