When I ran the LoadFromSQLServer on a machine that had sql & iis installed
on the same machine it worked perfectly.

But when I ran the LoadFromSQLServer from another machine (IIS only) - I get
error. Failed.
I copied the dts files needed to the IIS machine.
The SQL server is on a seperate server.

Here is my code:

Set oPkg= Server.CreateObject("DTS.Package")
oPkg.LoadFromSQLServer "sname", "user", "pass",DTSSQLStgFlag_Default ,
"pass", "", "", "SQLtoACCESSX"
oPkg.GlobalVariables("client_id").Value = "6"
oPkg.GlobalVariables("accessmdb").Value = "C:\Inetpub\wwwroot\hhd01.mdb"
oPkg.Execute()

Does this mdb file have to be on the IIS machine or the SQL machine. Does
this have to be the path on the IIS or SQL server?
"C:\Inetpub\wwwroot\hhd01.mdb"

DTS runs as a client process so the database specified here
oPkg.GlobalVariables("accessmdb").Value = "C:\Inetpub\wwwroot\hhd01.mdb"

needs to be on the IIS server

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"wahoo" <none (AT) none (DOT) com> wrote

I created another dts package no parameters -- if I execute by right
clicking and executing it works.
But if I do it through the web page it still does not work.

Again -- when I did the same thing on a server that had iis and sql server
on the same box - it worked.
Now that i execute the dts package in iis box that doesn't have sql - it
doesn't work.
The LoadFromSQLServer with no parameters, calls the sql server but when
executing the package it fails.
I checked the logs and it doesn't get recorded in the logs, so I can't check
why it fails.

Any ideas? Does the iis and sql server have to be on the same server to
work?

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

Thanks for the info.
I have done all the dll's and files on the IIS box w/out the sql server, but
it still fails.

The sql server has IIS turned off - I don't think that matters right.

DTS is client side, but it still executes the LoadFromSQLServer from the sql
server - even though I run it from IIS server, right?

Any other ideas? Do you know of anyone in my situation. 2 servers (1 IIS
and 1 SQL)


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

Hello, wahoo!

Did you read this article?

Execute a package from Active Server Pages (ASP)
http://www.sqldts.com/default.aspx?6,104,207,7,1


LoadFromSQLServer simply retrieves the package from the server you tell it
using the credentials you pass.



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: The sql server has IIS turned off - I don't think that matters right.

: DTS is client side, but it still executes the LoadFromSQLServer from the
sql
: server - even though I run it from IIS server, right?

: Any other ideas? Do you know of anyone in my situation. 2 servers (1 IIS
: and 1 SQL)

: "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
: news:eLdBGlSQDHA.1564 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
??>> Hello, wahoo!
??>>
??>> A quick thing you may be experiencing is that the DTS dlls are not
: installed
??>> on the server. DTS is a client side process.
??>>
??>> Redistributing DTS with your program
??>> http://www.sqldts.com/default.aspx?6,105,225,0,1
??>>
??>> --
??>>
??>> Allan Mitchell (Microsoft SQL Server MVP)
??>> MCSE,MCDBA
??>> www.SQLDTS.com
??>> I support PASS - the definitive, global community
??>> for SQL Server professionals - http://www.sqlpass.org
??>>
??>> : Again -- when I did the same thing on a server that had iis and sql
: server
??>> : on the same box - it worked.
??>> : Now that i execute the dts package in iis box that doesn't have sql -
it
??>> : doesn't work.
??>> : The LoadFromSQLServer with no parameters, calls the sql server but
when
??>> : executing the package it fails.
??>> : I checked the logs and it doesn't get recorded in the logs, so I
can't
??>> check
??>> : why it fails.
??>>
??>> : Any ideas? Does the iis and sql server have to be on the same server
to
??>> : work?
??>>
--- Microsoft Outlook Express 6.00.2800.1158