string strSourceConn = @"C:\Users\employee.txt"; string strDestConn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString(); string pkgLocation = @"D:\SSIS\Test\Integration Services Project1\Integration Services Project1\Package.dtsx"; Package pkg; Microsoft.SqlServer.Dts.Runtime.Application app; DTSExecResult pkgResults; app = new Microsoft.SqlServer.Dts.Runtime.Application(); pkg = app.LoadPackage(pkgLocation, null); //pkg.Variables["strSourceFile"].Value = strSourceConn; //pkg.Variables["DestinationFilePath"].Value = strDestConn; // pkgResults = pkg.Execute(); Variables vars; vars = pkg.Variables; vars["strSourceFile"].Value = strSourceConn; vars["DestinationFilePath"].Value = strDestConn; pkgResults = pkg.Execute(null, vars, null, null, null); //Response.Write(pkg.ExecutionResult); Response.Write("<script LANGUAGE='JavaScript' >alert('Saved Successfully')</script>");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)