| Author: Shivshanker Cheral 18 Sep 2009 | Member Level: Diamond | Rating:  Points: 2 |
refer
http://www.15seconds.com/issue/001102.htm
You can always use the BCP tool and wrap that into a batch file and then add an "Execute Process Task" to your package.
bcp "Select * from dbo..table FOR XML RAW" queryout c:\temp\test.xml -Soc-db -Uuser -Ppassword -c -r -t
|
| Author: Pooja 24 Sep 2009 | Member Level: Gold | Rating: Points: 2 |
Hi,
You can get the code to merge data from mdb file to XML format from one of my code snippets posted on dotnetspider. Below is the link which might help you.
http://www.dotnetspider.com/resources/29556-How-to-create-serialize-an-XML-file-from-xsd-and-.aspx
Cheers.
|