We have a VB.NET (.NET 2.0) windows service application that uses SQL Server DTS to send data to a central server. To access the DTS, we install Microsoft SQL Server 2000 Desktop Engine (MSDE) and then reference the DTS COM component.
We can then use then use DTS from within our service:
Dim m_pkg As DTS.Package2
m_pkg = New DTS.Package2
m_pkg.LoadFromSQLServer(...)
At the moment we are rebuilding this app in Visual Studio 2010, but using .NET 2.0 (due to constraints on the PCs). I wanted to know if there was a more lightweight / simplier way of installing the DTS components (so we can reference them) without installing MSDE. We are not using MSDE -- we just install it to use DTS.