Community-Credit.com | NonProfitWays.com | SOAPitstop.com   Skin:   
      User: Not logged in 
Home
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Presentations
Featured Articles
Book Chapters
Training Courses
Events
NewsGroups
 
Discussions
Examples
Tutorials
Tools
Articles
Resources
Websites
 
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
Logout
 
About Me
My Blog
HeadGeek Articles
Talking Portfolio
Resume
Pictures
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:

http://www.codenotes.com/articles/articleAction.aspx?articleID=172

 

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
DotNetSlackers
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)