Package package = null;
DTSExecResult result;
//connection manager
package = new Application().LoadPackage(packagePath + "\\importData.dtsx", null);
package.Connections["rs"].ConnectionString = connectionStr;
//variable
Variables vars = package.Variables;
vars["TenderNumber"].Value = tenderNum;
result = package.Execute();
if (result == DTSExecResult.Failure)
{
foreach (var e in package.Errors)
{
logHelper.Error("Package Execution Error", new Exception(e.Description));
}
throw new Exception(package.Errors[0].ToString());
}
Tuesday, October 30, 2012
Call SSIS package in C#
I need to call a SSIS package in a web application to import access data into SQL Server. However, I discover the performance is extremely low. And I don't know it's my personal problem or common issue. If possible, don't use it.
Labels:
.Net
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment