SQL Server Performance

XML Data Source Timeouts

Discussion in 'SQL Server 2005 Integration Services' started by Righteousman, Jul 11, 2008.

  1. Righteousman New Member

    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!
  2. satya Moderator

  3. moh_hassan20 New Member

    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.?

Share This Page