From: davidgr@iba.org.il   
      
   Hi   
      
   We use SqlServer 2008.   
   In an SSIS package I wanted to bring over a large table , a little more   
   than 600mb or in records ovrer 10 million.   
   The source table is in Ingres on a VMS server.   
   I defined a data flow using ADO.NET. When running the package it fails   
   because of a timeout after bringing over random ammounts of data   
   (between a third to over a half). It also takes AGES, over 30 minutes,   
   until it times out.   
   This is strange because the same kind of DTS in Sql 2000 used to copy   
   over the same table from Ingres without any problem and a lot quicker. I   
   looked at the timeout property but the numbers there are in seconds.   
   I solved the problem by copying it over as  a flat file to an Sql Server   
   destination, but still, the timeout issue wasn't solved.   
   Anyone have any idea and/or experiance with the timeout problem. either   
   in 2005 or 2008.   
      
   Thank you   
      
   David Greenberg   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)