i am using Darren Green's spExecutePKGGlobalVariables to execute a Package.
This package access a txt File in an other server and transfers data to SQL
server.

When i open Query Analyzer in the SQL Server Machine and execute package as
follows,it
fails.

EXEC spExecutePKGGlobalVariables
@Server='BZSQL2000',
@PkgName='TRANSFER2',
@IntSecurity=0,
@UserName ='sa',
@ServerPWD = '',
@GlobalV_1='SOURCEPATH=\\BZSRV\TXTFILES\TEST.TXT'

But if i change the Sourcepath , something like C:\TEST.TXT , it succeeds.

In the SQL Server Machine , I open the package in the EM, change the
sourcepath to network share and run the package , it succeeds!

it may be something about Security Context of the package running , but i
am not good at security issues.
what can i do to make the the package work with a network share when
executed within the sp in the query analyzer.

Thanks for your help.