| |   Skin:   
      User: Not logged in 
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Featured Articles
Book Chapters
Training Courses
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
About Me
My Blog
HeadGeek Articles
Talking Portfolio
World Trip Pics

Please report any errors or content that you would like changed in this page

Resource Name:

Using XSLT to Create BCP CSV and Format Files


Resource Description:

This example demonstrates using XSLT to output text files (as opposed to the usual HTML or XML files). Assume we have been given the following set of XML records and their schema and wish to store them in a database. Most relational databases support some kind of text-based import utility for just this purpose. In this example, we will transform the above XML files into two data files suitable for use with Microsoft SQL Server's command-line BCP (Bulk Copy Program) utility. We will have to convert the input XML into a comma-delimited DAT file, and an input XML schema into a space-delimited FMT file.


Resource URL:


Details of error:
Your Email Address: (Optional)  
Your Name:   (Optional)

Confirmation Code:


   Please enter the code shown below





Fans of "The Office"
Dwight Bobbleheads are here!
  “It's me! I'm the bobblehead! Yes!”

Advertise on XMLPitstop

Advertise on XMLPitstop

EggHead Cafe
Web Servicee development
hp printer refills
online fax services
conference call
internet fax
chicago web design
Alojamiento de Web
Cheap Web Hosting
License Plate Recognition System
Emporio armani sunglasses
Video Surveillance
VoIP Internettelefonie DE

3,894 Total Members
10 members(last 30 days)
1 members(last 7 days)
0 members(today)

1,945 Total Discussions
1 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

47,487 Total Blog Posts
0 Blogs(last 30 days)
0 Blogs(last 7 days)
0 Blogs(today)

8,699 Newsgroup Posts
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

14,094 Total Resources
1 Resources(last 30 days)
0 Resources(last 7 days)
0 Resources(today)