Hi -
I am porting a system from DTS to SSIS. The old version runs packages
programmatically loading and running a DTS.Package2 object. I can load and
execute and SSIS package using the Microsoft.SqlServer.Dts.DtsClient API, but
the package runs locally. I have a lot of questions about this, but there is
very little information available.

I would like to run the package on the server and just receive the output as
with any other server based system. Is this possible?

If it must run locally, what are the minimum requirements required on the
local system. Can I just have the client componnts installed? Or must I
have SSIS services (I would assume so). Do I need SQL server itself
installed?

Thanks,
Peter

Hello Peter,

You do not need SQL Server

Have a look at these topics in BOL


ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/9f6ef376-3408-46bf-b5fa-fc7b18c689c9.htm

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/610ee7d9-4fea-4aba-9395-57add826923b.htm



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan -

Thanks for your response. My BOL do not contain the links you posted, which
may explain why I am having trouble finding information. I do have the full
SQL 2005 Dev Edition installed (all help, samples etc) and VS 2005, so I
don't know why it is missing. If you know of anything extra I need installed
please let me know, otherwise could you post the article titles and I'll find
them on MSDN online? (hopefully).

Thanks again,
Peter

"Allan Mitchell" wrote: