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