Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS package Fails

Status
Not open for further replies.

xtreemnet

Programmer
Joined
Aug 9, 2003
Messages
88
Location
NZ
Hi,

I have created a SSIS package and deployed sucessfully on network server. I am trying to use Custom Log provider sample (HTML format). The package runs file from BIDS but when deployed on network server, It gives an error:

"Executed as user: HAMILTON\SQLAdmin. The package could not be loaded. The step failed."

When set the type of step run by OperatingSystem CmdExec

Then I get the following error:
Executed as user: HAMILTON\SQLAdmin. The process could not be created for step 1 of job 0x531F55DB8F3850438A72A8317FFFEE4B (reason: The system cannot find the file specified). The step failed.

I guess there seems to be a issue of permission to the html file the package is creating.

Cannot figure out how to solve this issue.

Please help,

Thanks,

 
you are executing the package under the user account of HAMILTON\SQLAdmin, does this user have all the rights across the network needed to complete the package?

--------------------
Procrastinate Now!
 
Check out Forum1555. That is for Microsoft SQL Server: Integration Services (SSIS) and is a better place to post your question.

-SQLBill

Posting advice: FAQ481-4875
 
SQLBill- Thanks for the information. Actually I tried to locate it but could not find. I will remember it for the future.

Crowley16 - I thought of that, but then it does not explain the fact that it works OK when the logging is done using the text file option available with SSIS. The text file is also located on the same drive as the html.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top