Hi, i am using SSIS script task in my project.. for some reason.. i need to add an XML file in to that SSIS script project ( which is dynamically generated).. my question is .. can we add XML file in SSIS script task? if so... Server.Mappath () to that file, which is added works? can i have sample please...Thaks, Kranthi Kumar. K

Hello Kranthi, to generate an XML file you can indeed use the Script Task to just directly write it or you can use two more elegant ways to generate it by the means of SQL query like mentioned here: http://blogs.msdn.com/b/jenss/archive/2009/11/06/an-secret-ssis-xml-destination-provider-you-might-not-found-yet.aspx or make your own XML Destination as posted here http://agilebi.com/jwelch/2007/06/02/xml-destination-script-component/ using a Script Transformation Component. Arthur My Blog