HI, I have developed a .net application( UI) and one SSIS Package. when some one selects some parameters from UI i need to invoke the SSIS Package . it is working fine locally , today i have deployed the .net code to Apllication Server where SQL Server was NOT Installed . there is no chance of installing SQL Server on application server . i am using below code : Package package = app.LoadFromSqlServer("Package", "ServerName", "user", "Password", null) Variables variables = package.Variables; variables["workname"].Value = "v2"; variables["Season"].Value = "SPring"; DTSExecResult result = package.Execute() I am getting error when i deployed the .net files in Application server saying that ManagedDTS.dll is not available.is there any way i can achieve the same functionality with out installing SQL server on Appplication server.

You dont need to install entire SQL SERVER but you would definitely need Sql Server Intergeration Services installed on that server.Rahul Kumar, MCTS, India, http://sqlserversolutions.blogspot.com/

As Rahul mentioned you have to install SSIS for this to work. You can have a look in the below similar thread also http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/d8674990-2188-4306-8d8b-58f4d4caf41a/

I have tried to install SSIS on Application Server but Admin is not allowing so i am looking for another option to achieve the same functionlaity. is it good idea to create one procedure where i can invoke the SSIS Package by using xp_cmdshell , dtexec ? or can i use sp_start_job ? my requirement is Admin is going to Select some parameters from .NET UI . after selecting the parameters the package need to invoke . these parameters are the input Variables for the package . To avoid the installing of SSIS i am trying to create on procedure which one can called after admin selects the input parameters. in that procedure i am trying to execute the package . am i doing correct ? or i am going in wrong direction ? Please help me