Interview Question in Sql Server 2000


 

Interview Question :: Help in SqlServer 2000

Create dts package in sql server 2000
that will execute stored procedure and display output as an xml file.

in short, i need,
steps To create an XML file from a SQL stored procedure in Sql Server 2000.
by ksk