Issue while runing the SSIS package pkg.Execute

• rajarajansudar

  SSC-Addicted

  Points: 470

  More actions

  November 27, 2014 at 12:31 am

  #312804

  I am executing the PKG using the below code

  Console.WriteLine("Package Execution Started");

  DTSExecResult executionResult = pkg.Execute();

  Console.WriteLine("Package Execution Completed with {0}", executionResult.ToString());

  I am getting error saying "To run a SSIS package outside of SQL Server Data Tools you must install sourceErrorDesc_POLICYTest of Integration Services or higher."

  I search in Google they say integration service need to install , as I using CITIX machine where my BIDS & SQL data tool is installed and I can create the package thru BIDS 2012 and execute them with out any issue

  will SSIS client fix this issue ? or do I need to install SQL server in my CITIX machine

  Any one plz help me

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  November 27, 2014 at 12:42 am

  #1761205

  You need to install Integration Services. You can do this with the SQL Server set-up.

  You don't need to install SQL Server itself.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP