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,
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,