here is my case:
web server runs a package on the database server with a stored procedure.
The package uses the text file in a share on the web server as a text file
source.

My question is how do i set the permissions of the share on the web
server?

thanks
Yener

And how do you fire the package? Using xp_cmdshell?

If it is then have a look here as to who actualy will do the calling of
the package

http://msdn.microsoft.com/library/de...aa-sz_4jxo.asp



"prefect" <uykusuz (AT) uykusuz (DOT) com> wrote

i am using LoadFromSqlserver method in the stored procedure.

i am really so confused. as far as i read , the package runs in the caller
but i am not sure about what that means.
i execute the stored procedure through a sql connection in the vb code at
the web server . Sp runs at the database server and loads the package and
exec it. am i wrong?
now who is the caller !? webserver or database server?

and whereever it is, under which user does the package run?

i know i ask too many question, but i did not understand what the
LoadFromSqlserver method does exactly. Does "Load" have a logical meaning
here just to access the package in the sql server?

for example: i load a package in the vb code or in a stored procedure
which resides in another server and this package uses a file with an
absolute path. in that case, can we say that package looks for the file in
the machine where the package is loaded ?

thanks
Yener



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

So what LoadFromSQLServer does is it retrieves from the MSDB on the
server you specify the package you asked for. It does not execute it.
It simply returns to you a Package object.

Pkg.Execute() will do the firing.

Are you using the sp_OA* family of procs?

Have a look here

http://www.databasejournal.com/featu...le.php/1459181

Allan



"prefect" <uykusuz (AT) uykusuz (DOT) com> wrote