March 3, 2008 at 11:40 am
Hi,
I created a SSIS package and executed it in command prompt using the dtexec utility and it ran fine. Hiowever, when I tried to do the same from sql server using the exteneded stored procedure xp_cmdshell, I got the following error:
Description: Failed to open package file "c:\documents and settings\133404\my documents\visual studio 2005\projects\integration services project5\integration services project5\MyFirstPackage.dtsx" due to error 0x80070005 "Access is denied.". This happ
ens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect
format.
This left me totally confused. Also, to check I executed a simple query from sql server query analyzer :
exec master.dbo.xp_cmdshell 'dir c:\temp\*.sql'
The path specified was not found. This gave me a feeling that may be I am missing on something. Though the sql server is in my machine and I am logging in using sysadmin role. Anyone has any clue about it?
March 3, 2008 at 11:45 am
Does the SQL Server service account have rights to the directory?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 3, 2008 at 12:48 pm
Does the SQL Server service account have rights to the directory?
Jack has hit the nail on the head. Confirm that the SQL service account has the appropriate permissions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply