We collect data daily from 300 branches via DTS.

Each branch connects to our server and uploads their data into our server by
running a DTS package that is on the server. They can do this, because each
branch has the (free) MSDE database installed, which includes DTS.dll and
this allows them to download the DTS package from the server and then run it
locally.

As we are upgrading to SQL Server 2005, we are considering replacing all the
DTS packages with SSIS packages. Will we still be able to run these SSIS
packages from each of the 300 branches without them all having to get a SQL
Server 2005 license ?

If that is possible, what do we need to do at the branch ? Do we install SQL
Server Express ? Or can we just install the SSIS component (like dts.dll for
DTS) ?

Thanks,
Craig