hi I am having table in sql server 2008..now i want to get XML destination how to do this in ssis

Hi, Check this tip on choosing the best destination adapters which gives you some clear idea on the using the destination task. http://beyondrelational.com/justlearned/posts/695/best-practice-to-choose-destination-addaptor-in-ssis.aspxThanks Karthikeyan Anbarasan http://f5debug.net/

Also check this where where ppl discussing moving the data has been converted from csv file to xml file which shows an xml destination is used for. http://beyondrelational.com/ask/public/questions/939/converting-csv-to-xml-file-format-using-ssis-t-sql-sql-server-2008-r2.aspxThanks Karthikeyan Anbarasan http://f5debug.net/

here is an other option: http://microsoft-ssis.blogspot.com/2010/12/flexible-xml-destination.html or http://ssisctc.codeplex.com/wikipage?title=XmlDestination&referringTitle=Home Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

ya thanks but when i used script component its shows "[SSIS.Pipeline] Information: "component "Script Component" (119)" wrote 0 rows." wat i do

Are there rows going in the Script Component when you run it in BIDS/Visual Studio?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

use the method shown here: http://businessincredulous.blogspot.com/2012/05/ssis-xml-output.html