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

Drag the Data Flow Task onto the Control Flow Surface. Double-click the "Data Flow Task" object to open up its design surface.

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.

Database Maintenance Tasks in SSIS Tools for keeping your SQL indexes in check. By Eric Johnson 05/10/2010 Do you have a large data import that leaves your indexes less than perfect?

I am working on a project that requires moving data from a large un-normalized access database to a new well constructed sql server database. I've already gone about moving the access db to Sql ...