March 13, 2013 at 4:08 pm
Newbie having an issue. I have job configured in sql agent to run a package on the file system.... Works fine
* uses a proxy account to query some table and output the results to a flat file on network. Proxy has ssisadmin privledges
But when i upload the package to integration services (msdb) and tell the job to access it via "SQL server" is fails. I get this error, Seems like the account permissions arent getting passed.
The owner, run as (proxy) stays the same while i switch back and forth between "File System" & "Sql Server" for testing
Executed as user: domain\user. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 3:04:38 PM Error: 2013-03-13 15:04:38.73 Code: 0xC020200E Source: Export records to text file Output File [2] Description: Cannot open the datafile "". End Error Error: 2013-03-13 15:04:38.73 Code: 0xC004701A Source: Export records to text file SSIS.Pipeline Description: Output File failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:04:38 PM Finished: 3:04:38 PM Elapsed: 0.234 seconds. The package execution failed. The step failed.
March 13, 2013 at 4:31 pm
Make sure the proxy account has db_ssisoperator role in the msdb.
March 13, 2013 at 4:37 pm
Added
db_ssisltduser
db_ssisoperator
In addition to already having db_ssisadmin, still no worky ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply