Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS Package Error Expand / Collapse
Posted Tuesday, September 22, 2009 11:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 11, 2015 3:46 AM
Points: 27, Visits: 203
Hi Guys,

I am trying to run package in SSIS and I am getting data validation error.

TITLE: Package Validation Error

Package Validation Error


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.




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.



Post #792367
Posted Thursday, September 24, 2009 7:51 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 5:10 PM
Points: 704, Visits: 258
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.
Post #793273
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse