January 12, 2015 at 3:22 am
Hello there,
I have a some SSIS-Stored-Packages. Running these jobs via "Run package", works fine, inluding logging.
Running the packages by Job, however, works also fine, except the Logging!
Looking in the Job history is see (for all the packages):
Executed as user: AD\SA_SQL_1234_SSIS_RiX. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4321.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 7:00:01 Error: 2015-01-12 07:00:19.14 Code: 0xC001401E Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name "E:\RiX\SSISLog\RiXSSISLog.txt" specified in the connection was not valid. End Error
Error: 2015-01-12 07:00:19.24 Code: 0xC0202070 Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error
Error: 2015-01-12 07:00:19.26 Code: 0xC0208024 Source: RiXLoad Log provider "SSIS log provider for Text files1"
Description: The connection manager "RiXSSISLog.txt" returned an object of an incorrect type from the AcquireConnection method. End Error
Error: 2015-01-12 07:00:19.27 Code: 0xC001401E Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name "E:\RiX\SSISLog\RiXSSISLog.txt" specified in the connection was not valid. End Error
Error: 2015-01-12 07:00:19.27 Code: 0xC0202070 Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error
Error: 2015-01-12 07:00:19.27 Code: 0xC0208024 Source: RiXLoad Log provider "SSIS log provider for Text files1"
Description: The connection manager "RiXSSISLog.txt" returned an object of an incorrect type from the AcquireConnection method. End Error
DTExec: The package execution returned DTSER_SUCCESS (0). Started: 7:00:01
Finished: 7:15:03 Elapsed: 901.811 seconds. The package executed successfully. The step succeeded.
Strange thing is that if I delete the logfile, the logfile will be created, but still no logging will be done and the error occurs.
Changing de path into an UNC-path does not resolve the problem.
Example
Applicationname:RiX
SSIS packagename:RiXLoad
SSIS-user:AD\SA_SQL_1234_SSIS
SQlServer-Agent-Logon:SA_SQL_AA02_NL123XXX999_default_Agent_O
Logging set toE:\RiX\SSISLog\RiXSSISLog.txt
Proxy name:PROXY_SA_SQL_1234_SSIS_RiX
Credential name:CREDENTIAL_SA_SQL_1234_SSIS_RiX
Credential Identity:AD\SA_SQL_1234_SSIS_RiX
Permissions
Permissions on E:\ "Traverse folder / Excecute file" (this folder only)
For the SSIS-user and the SQlServer-Agent-Logon
Permissions on E:\RiX "Full control" (this folder, subfolders and files)
For the SSIS-user and the SQlServer-Agent-Logon
Does anybody have an idea?
Thanks in advance!
January 13, 2015 at 1:29 am
If you need any further explanation, let me know...
January 13, 2015 at 6:33 am
ElKapy (1/12/2015)
Hello there,I have a some SSIS-Stored-Packages. Running these jobs via "Run package", works fine, inluding logging.
Running the packages by Job, however, works also fine, except the Logging!
Looking in the Job history is see (for all the packages):
Executed as user: AD\SA_SQL_1234_SSIS_RiX. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4321.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 7:00:01 Error: 2015-01-12 07:00:19.14 Code: 0xC001401E Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name "E:\RiX\SSISLog\RiXSSISLog.txt" specified in the connection was not valid. End Error
Error: 2015-01-12 07:00:19.24 Code: 0xC0202070 Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error
Error: 2015-01-12 07:00:19.26 Code: 0xC0208024 Source: RiXLoad Log provider "SSIS log provider for Text files1"
Description: The connection manager "RiXSSISLog.txt" returned an object of an incorrect type from the AcquireConnection method. End Error
Error: 2015-01-12 07:00:19.27 Code: 0xC001401E Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name "E:\RiX\SSISLog\RiXSSISLog.txt" specified in the connection was not valid. End Error
Error: 2015-01-12 07:00:19.27 Code: 0xC0202070 Source: RiXLoad Connection manager "RiXSSISLog.txt"
Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error
Error: 2015-01-12 07:00:19.27 Code: 0xC0208024 Source: RiXLoad Log provider "SSIS log provider for Text files1"
Description: The connection manager "RiXSSISLog.txt" returned an object of an incorrect type from the AcquireConnection method. End Error
DTExec: The package execution returned DTSER_SUCCESS (0). Started: 7:00:01
Finished: 7:15:03 Elapsed: 901.811 seconds. The package executed successfully. The step succeeded.
Strange thing is that if I delete the logfile, the logfile will be created, but still no logging will be done and the error occurs.
Changing de path into an UNC-path does not resolve the problem.
Example
Applicationname:RiX
SSIS packagename:RiXLoad
SSIS-user:AD\SA_SQL_1234_SSIS
SQlServer-Agent-Logon:SA_SQL_AA02_NL123XXX999_default_Agent_O
Logging set toE:\RiX\SSISLog\RiXSSISLog.txt
Proxy name:PROXY_SA_SQL_1234_SSIS_RiX
Credential name:CREDENTIAL_SA_SQL_1234_SSIS_RiX
Credential Identity:AD\SA_SQL_1234_SSIS_RiX
Permissions
Permissions on E:\ "Traverse folder / Excecute file" (this folder only)
For the SSIS-user and the SQlServer-Agent-Logon
Permissions on E:\RiX "Full control" (this folder, subfolders and files)
For the SSIS-user and the SQlServer-Agent-Logon
Does anybody have an idea?
What type of job step are you using?
EDIT: Is the logging supposed to be happening inside the package or do you have it set up in the job step itself?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply