I have developed an SSIS package and want to execute it from an application on a client machine. I can't seem to find the Microsoft.SqlServer.ManagedDTS assembly that I need to reference. Is this installed with the Visual Studio tools, SQL Server, or from a feature pack?

When you say you want to run on the client machine, do you want to start/launch it on the client machine a package that resides on a remote computer? See Running an SSIS Package Programmatically on a Remote Computer http://msdn.microsoft.com/en-us/library/ms403355.aspx Arthur My Blog

Install the SSIS on the machine which you want to run package, you can find it in sql server setup disk.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

I think it is also worth pointing out that SSIS is not a client application, so if you install it on a machine, that machine should be licensed as a full SQL Server, not just a user who has a client access license (CAL).http://www.sqlis.com | http://www.konesans.com