Ashwin_shastry
asked on
Errors while executing SSIS package as a SQL agent JOB
Hello,
I have a simple SSIS master package ,whose main task is to run other packages through the execute package tasks. The problem Iam facing is this. It runs fine when I run the package via BIDS but I get the following errors when I set up a job to run the Master Package.
Here is the error that I got the first time I ran this Master Package.
. Error 0xC0012050 while loading package file "D:\Data\AMF_DW_Incr_SSIS_ Solution\A MF_DW_Incr _SSIS\AMF_ DW_Incr_SS IS\FactBow lingCenter Sales_Incr _v2 (1).dtsx". Package failed validation from the ExecutePackage task. The package cannot run. . End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:38:27 PM Finished: 4:39:00 PM Elapsed: 32.25 seconds. The package execution failed. The step failed.
I got a couple of soultions on the internet which basically asked me to change a few settings in the Host (Master package in my case). Here is the link
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/43c84491-66f8-4a61-bd97-54a824d56be7/
I changed the DelayValidation=TRUE on the Master package and made it false in the child package , but I still kept getting the same error. I also changed the DelayValidation=TRUE on Execute package task in the Master package, but it kept failing at the same point.
Now Since we have a proxy account set up for the Data warehouse task , I changed the Job to use the proxy account instead of the default sql server account.
Now the master package failed even before it reached the place it was reaching before. and here is the error.
Executed as user: AMF\DWSSISProxy. ...on 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:49:27 PM Error: 2009-04-16 16:49:38.28 Code: 0xC001404B Source: Master_Daily Log provider "SSIS log provider for Text files" Description: The SSIS logging provider has failed to open the log. Error code: 0x80070005. Access is denied. End Error Error: 2009-04-16 16:49:38.28 Code: 0xC001404B Source: Master_Daily Log provider "SSIS log provider for Text files" Description: The SSIS logging provider has failed to open the log. Error code: 0x80070005. Access is denied. End Error Error: 2009-04-16 16:49:38.45 Code: 0xC0202009 Source: dimAccount_Incr Log provider "SSIS log provider for SQL Server" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x8004... The package execution fa... The step failed.
Hoping for some help...
Ashwin
I have a simple SSIS master package ,whose main task is to run other packages through the execute package tasks. The problem Iam facing is this. It runs fine when I run the package via BIDS but I get the following errors when I set up a job to run the Master Package.
Here is the error that I got the first time I ran this Master Package.
. Error 0xC0012050 while loading package file "D:\Data\AMF_DW_Incr_SSIS_
I got a couple of soultions on the internet which basically asked me to change a few settings in the Host (Master package in my case). Here is the link
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/43c84491-66f8-4a61-bd97-54a824d56be7/
I changed the DelayValidation=TRUE on the Master package and made it false in the child package , but I still kept getting the same error. I also changed the DelayValidation=TRUE on Execute package task in the Master package, but it kept failing at the same point.
Now Since we have a proxy account set up for the Data warehouse task , I changed the Job to use the proxy account instead of the default sql server account.
Now the master package failed even before it reached the place it was reaching before. and here is the error.
Executed as user: AMF\DWSSISProxy. ...on 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:49:27 PM Error: 2009-04-16 16:49:38.28 Code: 0xC001404B Source: Master_Daily Log provider "SSIS log provider for Text files" Description: The SSIS logging provider has failed to open the log. Error code: 0x80070005. Access is denied. End Error Error: 2009-04-16 16:49:38.28 Code: 0xC001404B Source: Master_Daily Log provider "SSIS log provider for Text files" Description: The SSIS logging provider has failed to open the log. Error code: 0x80070005. Access is denied. End Error Error: 2009-04-16 16:49:38.45 Code: 0xC0202009 Source: dimAccount_Incr Log provider "SSIS log provider for SQL Server" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x8004... The package execution fa... The step failed.
Hoping for some help...
Ashwin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, I encourage you to use UNC naming for all file locations. \\server\path\file