ssis package execution problem from c#

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply