Cannot execute SSIS package in ASP.Net 2.0 application?
- From: nkw <nkw@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Dec 2006 12:38:03 -0800
I have the following code to execute a SSIS package loaded from file system:
(I can use dtexec to run the package without problem). The package will
delete rows in an Access MDB file. I already set everyone have full control
of the MDB file. Any clue? tia.
Application app = new Application();
Package package =
app.LoadPackage(ConfigurationManager.AppSettings["ssisPackageFileName"],
null);
package.ImportConfigurationFile(ConfigurationManager.AppSettings["ssisPackageConfig"]);
DTSExecResult result = package.Execute();
if (result != DTSExecResult.Success)
lblMsg.Text += "Create MDB file failed.";
However, I always got the following information:
#Fields:
event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
PackageStart,dbserver001,NT AUTHORITY\NETWORK
SERVICE,DD_Downloads,{EA5AE2A2-2ECB-445E-BA2D-CAD077F5CFE6},{42B39FF0-F079-4628-99B4-2F26FDF5269E},12/5/2006
3:21:54 PM,12/5/2006 3:21:54 PM,0,0x,Beginning of package execution.
OnError,dbserver001,NT AUTHORITY\NETWORK SERVICE,Clear data -
Defaults,{D64EDB6B-CC5F-465F-8BA0-718A0DA34504},{42B39FF0-F079-4628-99B4-2F26FDF5269E},12/5/2006
3:22:02 PM,12/5/2006 3:22:02 PM,-1073548784,0x,Executing the query "delete
from OutputDefaults" failed with the following error: "Could not delete from
specified tables.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
OnError,dbserver001,NT AUTHORITY\NETWORK
SERVICE,DD_Downloads,{EA5AE2A2-2ECB-445E-BA2D-CAD077F5CFE6},{42B39FF0-F079-4628-99B4-2F26FDF5269E},12/5/2006
3:22:02 PM,12/5/2006 3:22:02 PM,-1073548784,0x,Executing the query "delete
from OutputDefaults" failed with the following error: "Could not delete from
specified tables.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
OnTaskFailed,dbserver001,NT AUTHORITY\NETWORK SERVICE,Clear data -
Defaults,{D64EDB6B-CC5F-465F-8BA0-718A0DA34504},{42B39FF0-F079-4628-99B4-2F26FDF5269E},12/5/2006 3:22:02 PM,12/5/2006 3:22:02 PM,0,0x,(null)
OnWarning,dbserver001,NT AUTHORITY\NETWORK
SERVICE,DD_Downloads,{EA5AE2A2-2ECB-445E-BA2D-CAD077F5CFE6},{42B39FF0-F079-4628-99B4-2F26FDF5269E},12/5/2006
3:22:02 PM,12/5/2006 3:22:02 PM,-2147381246,0x,The Execution method
succeeded, but the number of errors raised (1) reached the maximum allowed
(1); resulting in failure. This occurs when the number of errors reaches the
number specified in MaximumErrorCount. Change the MaximumErrorCount or fix
the errors.
PackageEnd,dbserver001,NT AUTHORITY\NETWORK
SERVICE,DD_Downloads,{EA5AE2A2-2ECB-445E-BA2D-CAD077F5CFE6},{42B39FF0-F079-4628-99B4-2F26FDF5269E},12/5/2006
3:22:02 PM,12/5/2006 3:22:02 PM,1,0x,End of package execution.
.
- Follow-Ups:
- Re: Cannot execute SSIS package in ASP.Net 2.0 application?
- From: Allan Mitchell
- Re: Cannot execute SSIS package in ASP.Net 2.0 application?
- Prev by Date: Scheduled SSIS package as job fails
- Next by Date: Re: Cannot execute SSIS package in ASP.Net 2.0 application?
- Previous by thread: Scheduled SSIS package as job fails
- Next by thread: Re: Cannot execute SSIS package in ASP.Net 2.0 application?
- Index(es):
Relevant Pages
|
