August 20, 2015 at 11:24 am
I have simple package that is writing data from a SQL query to file.. I have included the message from BIDS run, but the file is not getting created and there is no error message. I am guessing that it is a permission issue, but how do I get SSIS to tell me why the file is not getting created?
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Destination [34]: The processing of file "\\r2d2\mimi\a_test.txt" has started.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Destination [34]: The processing of file "\\r2d2\mimi\a_test.txt" has ended.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "Flat File Destination" (34)" wrote 3 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
SSIS package "Package.dtsx" finished: Success.
August 20, 2015 at 2:12 pm
Hi
It looks you have permissions to write, but read & execute are denied.
Br.
Mike
August 21, 2015 at 9:57 am
michal.lisinski (8/20/2015)
HiIt looks you have permissions to write, but read & execute are denied.
Br.
Mike
How can you tell?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply