Hello, I've got a Data Flow that uses an XML Data Source to retrieve data, which then extracts into a table. Works great for smaller data sets, however when I have a fairly large data set it times out. I've debugged into the code that generates the XML and it takes about 2 minutes to generate, then sends the data -- however the XML Data Source task times out before the XML data is fully generated. Does anyone know how to increase the timeout of the XML Data Source? I can't find it in any of the properties. Thanks!
I refer this http://msdn.microsoft.com/en-us/library/ms345118.aspx documentation to fine tune the relevant data performance issues. Hope this helps.
if you use sql server 2005 , you can save xml nativly in staging table with column of type xml , and do the process needed. what the process you do in xml? can you do that process in the server side using stored procedure.?