SSIS to export XML.
-
Hi,
I m trying to perform same as suggested by you.
But while the execution of 'Execute SQL' task I m getting the below mentioned error:
"[Execute SQL Task] Error: Executing the query "SELECT TOP 5 * FROM dim_rms_trade_cat FOR xml auto, elements, root" failed with the following error: "A name contained an invalid character. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. "
But the same query is executing successfully in QA.
Please if you can help me in this.
-
That occurs when you have unrepresentable characters in your data. See here for more information: http://stackoverflow.com/questions/397250/unicode-regex-invalid-xml-characters
If you want this done for you automatically the XML SSIS Toolkit from Keelio Software automatically data cleanses incoming data to conform to the XML specification. See here http://www.keelio.com
-
I used a method posted above and it created strange output but then I combined it with a technique I saw on another post and I got it to work great.
See my blog post (with graphics) for a simple SQL query and Script.
Nothing to download, very little to code. Fast and easy.
http://businessincredulous.blogspot.com/2012/05/ssis-xml-output.html
-
Hello,
I have gone through your post and got your query, I have googled and Got one relevant sites where They have discussed all points regarding SSIS to export XM[/url]L. They have a "Help" section where they have explained sample work and they have alsoa elevant video with task. I am sharing URL here.Please Have a look.
http://zappysys.com/products/ssis-powerpack/ssis-xml-source/
Hope it will be helpful.
-
Hello Tim Heap,
SSIS XML[/url] Source Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit).
Try This link-
http://zappysys.com/products/ssis-powerpack/ssis-xml-source/
Viewing 5 posts - 31 through 35 (of 35 total)
You must be logged in to reply to this topic. Login to reply