June 13, 2014 at 8:25 am
Hello Everybody,
I'm trying to export data from a table in database server to flat file in another server, however it is happening the error Access Denied. I'm using SQL Server Integration Service 2008 R2 to do this.
I've checked all the ways that's happening could the level of security and could not resolve.
Please could someone tell me what I'm missing in this case?
Following error log:
SSIS package "AtualizarDados.dtsx" starting.
Information: 0x4004300A at Gerar arquivo, SSIS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Gerar arquivo, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Gerar arquivo, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Gerar arquivo, Geração de Arquivo [63]: The processing of file "\\targetserver\Export_File\Export_File.txt" has started.
Warning: 0x80070005 at Gerar arquivo, Geração de Arquivo [63]: Access is denied.
Error: 0xC020200E at Gerar arquivo, Geração de Arquivo [63]: Cannot open the datafile "\\targetserver\Export_File\Export_File.txt".
Error: 0xC004701A at Gerar arquivo, SSIS.Pipeline: component "Geração de Arquivo" (63) failed the pre-execute phase and returned error code 0xC020200E.
Information: 0x40043008 at Gerar arquivo, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Gerar arquivo para DMZ, Geração de Arquivo [63]: The processing of file "\\targetserver\Export_File\Export_File.txt" has ended.
Information: 0x4004300B at Gerar arquivo, SSIS.Pipeline: "component "Geração de Arquivo" (63)" wrote 0 rows.
Information: 0x40043009 at Gerar arquivo, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Gerar arquivo
SSIS package "AtualizarDados.dtsx" finished: Success.
Regards,
Antonio Estima
June 13, 2014 at 10:59 am
Does the file already exist in the remote location?
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
June 16, 2014 at 10:37 am
Yes, does.
I have put an AD account with administratives permissios to running SQL Agent and SQL Server Integration Services. Finally, I have created a proxy with this user and nothing the error message still it is showing to us.
Regards,
Antonio Estima
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply