iS IT Posibble generate the .CSV File using xml task. my source file is xml file...

you can simply use a Data Flow Task then use a XML Source and then use Flat File Destination if the xml be complex then you need to flatten it with xml task before passing it to data flowhttp://www.rad.pasfu.com

To answer your question. I believe that you might be able to generate CSV using the XML Task (using XSLT). But I believe that you can achieve the same using Reza's technique.Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008

Hi vamsi1980, Please refer to the following link: http://blog.hoegaerden.be/2011/04/20/loading-complex-xml-using-ssis/ Thanks, Eileen

As per my requirement i want to use xml task... can u provide any link

See here, you can output either csv or xml: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2c68c516-1856-4744-a0b8-c56a9815c164/Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File SSIS Centralize Connection Repository