I want to create a DTS package that will convert SQL 2000 data into an XML format. As an fyi, I figured out how to extract the data using the SELECT...For XML Explicit statement. What must I define within this DTS package, in terms of setting up a task and/or connection, so that so that the export file created is in AML format?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
create XML export file within DTS
- Thread starter rq
- Start date
- Status
Similar threads
- Locked
- Question