Hey friendz,

I've developed a DTS package from importing data from excel files to
SQL Server and its working according to the requirement except that I
want the transform task to be in a transaction & it should rollback if
any error occurs or else commit the transaction. I've tried using the
transform options but still no use.

How will i achieve this in DTS?

Are you saying you specified Use Transactions and "Commit on
successfull completion" in the packages properties under the advanced
tab?