I have migrated a DTS package to SSIS 2008 packages. The old DTS packages use transanction (with commit on successfull pkg completion) and the transanction isolation level was "Read Committed". But When I migrated the package to SSIS 2008,the transanction option is "supported" and isolation level is "serializable". I think these are the default options in SSIS 2008. Do I need to change them to correspond to the previous DTS package behaviour or leave them as it is? Thank you for all your replies.

Have a read of http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3dcea5f6-32ef-40aa-90d5-0f2fef9e1d38 Cheers JeffJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)

Have a read of http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3dcea5f6-32ef-40aa-90d5-0f2fef9e1d38 Cheers JeffJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)

Thanks a lot jeff. So, I think in DTS ans SSIS 2005 the default isolation transaction property was "Read Comitted". But in SSIS 2008 I think it is defaulted to "serializable" and transaction option as "supported"?

I can't remember what the defaults were for DTS as it has been quite a number of years since I've used DTS. One thing to remember is that using serializable has the potential to lock out anyone else trying to make changes to data your packages may be accessing i.e. if you are selecting, inserting, updating or deleting data in a database, other users will not be able to make changes to this data while your package is executing. There can also be potential performance issues if the data you are processing is large as the database will need to use more resources to acquire the locks it needs to process data. Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)