Depolyment Error


  • Hi,

      I created a package in development machine and depolyed to production side.SSIS package is working in fine after deployment in production and also in development side.but if i scheduled the package i got a error like this,

    "Executed as user: Domain\TEST$. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  12:27:19  Error: 2013-10-28 12:27:20.07     Code: 0xC020200E     Source: Delta File Load 1 Flat File Destination [3120]     Description: Cannot open the datafile

    "Z:\Weekly Delta Files\SchedulingUserPermission.csv".  End Error  Error: 2013-10-28 12:27:20.07     Code: 0xC004701A     Source: Delta File Load 1 SSIS.Pipeline     Description: component "Flat File Destination" (3120) failed the pre-execute phase and returned error code 0xC020200E.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  12:27:19  Finished: 12:27:20  Elapsed:  1.031 seconds.  The package execution failed.  The step failed."

       If my destination in C drive,its working fine.but when i use share drive i got a problem.but i am having access to that share drive. Can anybody please help for this problem.

    Tuesday, October 29, 2013 5:42 AM


All replies