September 22, 2009 at 11:16 pm
Hi Guys,
I am trying to run package in SSIS and I am getting data validation error.
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Test_ETL [Log provider "SSIS log provider for XML files"]: The SSIS logging provider has failed to open the log. Error code: 0x80070003.
The system cannot find the path specified.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
I have checked the event log path, as well as output file path and I can see the GLCenter_stageload.dtsx in bin folder. However, I have noticed one thing I am running driver_Zone package it’s trying to contact GLCenter. Can anyone specific which path do I need to check. I have even checked my SQL server permissions, do I need to check any other permissions.
Note: Package was developed by another developer and he is no more with our company. We use common event log folder and output folder. However, when I run the package I am getting above error
Can anyone shed some light please.
Thanks,
D
September 24, 2009 at 7:51 am
The error indicates that it is the package execution log file that has the problem. Open your package in BIDS then click SSIS...Logging on the menu. When the "Configure SSIS Logs" dialog opens, you should see a configured SSIS log provider for XML in the "Select the logs to use for the container" box. The configuration column of the log provider should tell you what folder you're having a problem with.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply