"prefect" <uykusuz@uykusuz.com> wrote in message
news:eI%23pRy82FHA.400@TK2MSFTNGP09.phx.gbl...
>i am a little bit confused , i write an sp which creates DTS.Package object
>and uses LoadFromSQLServer method to load DTS package.
> i exec this sp within VB code in a ASP page. Web server and Sql server are
> on the different machines. where does the package run ? on the web server
> or sql server?
> what if i load the package using the VB code instead of a stored
> procedure?
>
> this is important because i plan to use a filepath as a global variable ,
> and set it as a source for one of my tasks.
>

> DTS is a SQL Server's feature. Logically speaking ....It should run on
> SQL Server even though you call from web server.
>
> A Panchanathan
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:d4c9a652174108c7aa8ba9f62160@msnews.microsoft.com...
> Hello Panch,
>
> No, DTS is a client application and runs from whereever you call it.
>
> If I am in N.Y. and I grab a package in EM from a server in London that
transfers
> data between two london servers then the data does this
>
>
> London --> N.Y. --> London
>
>
> Allan
>
> > DTS is a SQL Server's feature. Logically speaking ....It should run on
> > SQL Server even though you call from web server.
> >
> > A Panchanathan
> >
>
>

"uykusuz" <ad> wrote in message
news:uEhU9CH3FHA.2872@TK2MSFTNGP15.phx.gbl...
> Allan, then
> in my case , can we say that the package runs on the webserver?
> and text source would reside on the webserver?
> eg: when i give a path like C:\source.txt ,the package would look for it
> on the webserver?
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:d4c9a652174108c7aa8ba9f62160@msnews.microsoft.com...
> > Hello Panch,
> >
> > No, DTS is a client application and runs from whereever you call it.
> >
> > If I am in N.Y. and I grab a package in EM from a server in London that
> transfers
> > data between two london servers then the data does this
> >
> >
> > London --> N.Y. --> London
> >
> >
> > Allan
> >
> > > DTS is a SQL Server's feature. Logically speaking ....It should run on
> > > SQL Server even though you call from web server.
> > >
> > > A Panchanathan
> > >
> >
> >
>
>