Working with Transaction Cotainers for Jet Oledb provider @SSIS

Issue: If you try to user transaction container, and if your data flow task contains Jet oledb provider then transactions will not work.

Solution: User Excel or other source in place of Jet oledb provider.