January 4, 2010 at 10:15 am
I am running SQL 2005 Edition, when I can run my SSIS pacakge through BI with same logon it works but when I try through JOB getting "Access denied" following error
I logon as a Application adm, but it is execute as a sysadm logon may be that the error, but do you know how to change it.
Executed as user:< System logon >. ...sion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:02:01 PM Error: 2010-01-04 12:02:01.92 Code: 0xC0011007 Source: {125C5A8C-39E6-4C28-BB58-7801DE315D84} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2010-01-04 12:02:01.92 Code: 0xC0011002 Source: {125C5A8C-39E6-4C28-BB58-7801DE315D84} Description: Failed to open package file "C:\Documents and Settings\svctaske\My Documents\Visual Studio 2005\Projects\Load_table\Load_table\<NAME>.dtsx" due to error 0x80070005 "Access is denied.". This happens 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 Loa... The package could not be f... The step failed.
January 4, 2010 at 12:49 pm
Are you storing your package in MSDB or in the filesystem?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 4, 2010 at 12:53 pm
I am storing on filesystem, my one other question when I save the package on system ssis package, how can I see these these OR how can I see the SSIS pacakage on SQL server management studio
January 4, 2010 at 1:01 pm
MAK-1128556 (1/4/2010)
I am storing on filesystem, my one other question when I save the package on system ssis package, how can I see these these OR how can I see the SSIS pacakage on SQL server management studio
To see them on SQL Server, they need to be stored in the SSIS store (MSDB).
As for the other part, You will need to make sure the user running the job (SQL Agent service account) has permissions to the directory and package.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 4, 2010 at 1:06 pm
Thanks, whow can i see these SSIS packages in SQL management Studio
January 4, 2010 at 1:14 pm
MAK-1128556 (1/4/2010)
Thanks, whow can i see these SSIS packages in SQL management Studio
Click the Integration Services button from Registered Servers. This will list the Registered SSIS Servers that you have.
Expand Integration Services in the Registered Servers Pane, Expand Local Server Groups, and then Open the server that you saved the package to.
Then you will be able to drill down to the packages from Object Explorer. Server...Stored Packages...(File System or MSDB)...then you will see a list of packages.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 4, 2010 at 1:57 pm
Thanks, I got it
January 4, 2010 at 2:05 pm
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2010 at 2:48 am
Thanks for the directory security tip. Saved me lots of frustration.
In SQL there are no absolutes, it always depends...
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply