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.

    🙂

    SSIS Json source[/url] : The Json file soure is used to to read data from Json file. We have mentioned source code with example.

  • 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/

    SSIS Json source[/url] : The Json file soure is used to to read data from Json file. We have mentioned source code with example.

Viewing 5 posts - 31 through 34 (of 34 total)

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