Hi Guys, Could you please guide me that how can I generate XML file from SQL database by using SSIS package. I want to convert couple of my sql database tables into XML. tHANKS IN Advance,

Don't use SSIS, use bcp from SQL Server: http://msdn.microsoft.com/en-us/library/ms187042.aspxJames Beresford @ www.bimonkey.com & @BI_Monkey SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

You can create XML without SSIS, just using T-SQL. Check the articles below: http://www.simple-talk.com/sql/t-sql-programming/beginning-sql-server-2005-xml-programming/ http://blog.sqlauthority.com/2009/02/12/sql-server-simple-example-of-creating-xml-file-using-t-sql/ http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/create-xml-files-out-of-sql-server-with-SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Don't use SSIS, use bcp from SQL Server: http://msdn.microsoft.com/en-us/library/ms187042.aspxJames Beresford @ www.bimonkey.com & @BI_Monkey SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

You can create XML without SSIS, just using T-SQL. Check the articles below: http://www.simple-talk.com/sql/t-sql-programming/beginning-sql-server-2005-xml-programming/ http://blog.sqlauthority.com/2009/02/12/sql-server-simple-example-of-creating-xml-file-using-t-sql/ http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/create-xml-files-out-of-sql-server-with-SSIS Tasks Components Scripts Services | http://www.cozyroc.com/