July 18, 2008 at 2:00 am
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