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

Refer this resource to a friend

Friend's Email Address:
Your Name: (optional)
Your Email: (optional)

 

 

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

 

Notes

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
Canon compatible cartridges
conference call service
spoc
it outsourcing
chicago web design
Alojamiento Web
UK Web Hosting
Samsung Security Camera DVR
Christian Dior sunglasses
Video Surveillance
Hosted Exchange, SDSL

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)