Re: Cannot execute SSIS package in ASP.Net 2.0 application?

#1

Hello nkw,

This looks like a permissions problem. The package executes so the calling
code is not an issue. it is when you go to do something in the package that
it fails.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

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(ConfigurationManag er.AppSettings["ssis
PackageConfig"]);
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,executioni d,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-99
B4-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-99
B4-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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Cannot execute SSIS package in ASP.Net 2.0 application?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Cannot execute SSIS package in ASP.Net 2.0 application? - 12-05-2006 , 03:22 PM