Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-10 : 08:16:16
|
| Craig writes "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" |
|
|
|
|
|
Upgrading DTS to SQL Server Integration Services