InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:24:35 GMT20http://www.sqlservercentral.com/Forums/Topic536542-387-1.aspxHi allbelow 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(); [b] if (status == "Success") { pack = app1.LoadPackage(Server.MapPath(ConfigurationManager.AppSettings["SSASPackage"].ToString()), null); DTSExecResult result = pack.Execute(); }[/b]any one plzzzzz help.....RegardsMadhuFri, 18 Jul 2008 02:00:15 GMTmadhu15583