Generate XML file without using BCP utility

Question

Generate XML file without using BCP utility

karthick_frd

SSC Journeyman

Points: 90
More actions
December 14, 2009 at 5:41 am

#103864

Hi All,
How to generate xml file without using bcp utility.
please help me out of this problem.
Regards
Karthick S 🙁

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

SSIS can do it.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

WayneS SSC Guru Points: 95461 More actions · Answer 2

You can also utilize the sp_OA procedures with "Scripting.FileSystemObject" to create a file with whatever text in it you want.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

karthick_frd SSC Journeyman Points: 90 More actions · Answer 3

Wayne & RBarryYoung :

Thanks for the response.

Regards,

Karthick