ssis package execution problem from c#

• madhu15583

  SSC Enthusiast

  Points: 134

  More actions

  July 18, 2008 at 2:00 am

  #189774

  Hi all

  below code is working fine in my local machine.

  but in production server the last package(SSASPackage) is not executing from the application but if i execute it manually its working fine.

  Application app1 = new Application();

  Package pack = app1.LoadPackage(Server.MapPath(ConfigurationManager.AppSettings["DTSExcelPackage"].ToString()), null);

  if(FileName.ToLower().EndsWith("xls"))

  {

  pack = app1.LoadPackage(Server.MapPath(ConfigurationManager.AppSettings["DTSExcelPackage"].ToString()), null);

  }

  if (FileName.ToLower().EndsWith("csv"))

  {

  pack = app1.LoadPackage(Server.MapPath(ConfigurationManager.AppSettings["DTSCSVPackage"].ToString()), null);

  }

  Variables vars = pack.Variables;

  vars["con"].Value = ConfigurationManager.ConnectionStrings["DBConnection2"].ToString();

  vars["Filepath"].Value = FileName;

  vars["RapportRunID"].Value = RunID;

  vars["TableName"].Value = Table;

  vars["ExecuteSchema_SP"].Value = " EXEC sp_starschema '" + Table + "', '" + RunID + "' ";

  DTSExecResult res = pack.Execute();

  string status = res.ToString();

  if (status == "Success")

  {

  pack = app1.LoadPackage(Server.MapPath(ConfigurationManager.AppSettings["SSASPackage"].ToString()), null);

  DTSExecResult result = pack.Execute();

  }

  any one plzzzzz help.....

  Regards

  Madhu