Hi there,<BR><BR>Yeah, XML data flow task tries to read the whole file into memory first, no workaround for that I'm afraid.<BR><BR>I guess you could get your hands on some piece of XML parsing ...

Do you want to backup your current database before you run a purge package? You are in luck; SSIS contains a handful of database maintenance tasks for these and other special occasions.