September 22, 2010 at 2:37 pm
Hi,
I was trying to modify a SSIS package from server based to File based.
When we were running the SSIS from server it used to work fine although the path for the log file did not exist.
Now when I was trying to make it a filed based SSIS package with the same path for Log file It fails. and getting the following error. This path was mentioned in the Config file
The SSIS logging provider has failed to open the log. Error code: 0x80070003.
The system cannot find the path specified. Its a Package validation Error
can some one help me out on this
September 22, 2010 at 5:08 pm
sravan.here (9/22/2010)
Hi,I was trying to modify a SSIS package from server based to File based.
When we were running the SSIS from server it used to work fine although the path for the log file did not exist.
Now when I was trying to make it a filed based SSIS package with the same path for Log file It fails. and getting the following error. This path was mentioned in the Config file
The SSIS logging provider has failed to open the log. Error code: 0x80070003.
The system cannot find the path specified. Its a Package validation Error
Check if the path exists then check if appropriate privileges are granted.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 22, 2010 at 5:13 pm
Path does not exist..... but it worked in the older version(on server based)....the problem is when i am converting to Filed based its failing
and yes i have sufficient privilages
September 22, 2010 at 5:15 pm
sravan.here (9/22/2010)
Path does not exist..... but it worked in the older version(on server based)....the problem is when i am converting to Filed based its failing
Pre-create the path all the way to last directory level.
sravan.here (9/22/2010)
...and yes i have sufficient privilages
Not you, the target directory 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 22, 2010 at 5:49 pm
PaulB-TheOneAndOnly (9/22/2010)
sravan.here (9/22/2010)
Path does not exist..... but it worked in the older version(on server based)....the problem is when i am converting to Filed based its failingPre-create the path all the way to last directory level.
I have to find out with the Admin whether I can pre-create the path....
But the problem I did not understood was why was the earlier SSIS package working fine even then the directory path did not existed.
but when i am trying to modify it to file based package it fails
and I really thank you for your Quick reply 🙂
sravan.here (9/22/2010)
...and yes i have sufficient privilagesNot you, the target directory 🙂
as the directory does not exists, I think there is no issue of access permissions
Hope this issue will be solved soon.....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply