from an
ASP (VB)script and would appreciate any and all response. *I don't
even
know if it's possible
Thanks
- Chuck Gatto
Dan Guzman Apr 27 2000, 12:00 am show options
Newsgroups: comp.databases.ms-sqlserver
From: "Dan Guzman" <DGuz...@nospamplease-earthlink.net&g*t; - Find
messages by this author
Date: 2000/04/27
Subject: Re: Executing a DTS Package using an ASP (VBScript) Script
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse
This VBScript example loads and executes an existing DTS pac*kage from
SQL
Server.
Option Explicit
Const PackageName = "PackageName"
Const ServerName = "ServerName"
Const UserName = "UserName"
Const Password = "Password"
Dim DTSPk
Set DTSPk = CreateObject("dts.package")
DTSPk.LoadFromSQLServer ServerName, UserName ,Password
,,,,,*PackageName
DTSPk.Execute
If DTSPk.Steps(1).ExecutionResult = 0 Then
Response.Write "Package execution completed"
Else
Response.Write "Package execution failed"
End If
Set DTSPk = Nothing
You can also create the entire package from scratch from wit*hin your
asp and
execute it.
Hope this helps.
Chuck Gatto <cga...@anchorsystems.com> wrote in message
news:8e**********@slb7.atl.mindspring.net...
- Hide quoted text -
- Show quoted text -
I'm looking for an example of how to execute an existing D*TS package from
an ASP (VB)script and would appreciate any and all response.* I don't even know if it's possible
Thanks
- Chuck Gatto
Chuck Gatto May 1 2000, 12:00 am show options
Newsgroups: comp.databases.ms-sqlserver
From: "Chuck Gatto" <cga...@anchorsystems.com> - Find messages by this
author
Date: 2000/05/01
Subject: Re: Executing a DTS Package using an ASP (VBScript) Script
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse
Below code works 100% in VB but the load fails in ASP. I g*et...
"Microsoft OLE DB Provider for SQL Server. Login failed for *user "\".
error.
I think the IIS (server a) is set for NT auth. and sql7 (on *server b)
as
well but I can't be sure.
Any idea what I should look for.
Thanks
"Dan Guzman" <DGuz...@nospamplease-earthlink.net> wrote in m*essage
news:sg***********@corp.supernews.com...
- Hide quoted text -
- Show quoted text -
This VBScript example loads and executes an existing DTS p*ackage from SQL Server. Option Explicit
Const PackageName = "PackageName"
Const ServerName = "ServerName"
Const UserName = "UserName"
Const Password = "Password"
Dim DTSPk
Set DTSPk = CreateObject("dts.package")
DTSPk.LoadFromSQLServer ServerName, UserName ,Password ,,,*,,PackageName DTSPk.Execute
If DTSPk.Steps(1).ExecutionResult = 0 Then
Response.Write "Package execution completed"
Else
Response.Write "Package execution failed"
End If
Set DTSPk = Nothing
You can also create the entire package from scratch from w*ithin your asp
and execute it.
Hope this helps.
Chuck Gatto <cga...@anchorsystems.com> wrote in message
news:8e**********@slb7.atl.mindspring.net...I'm looking for an example of how to execute an existing* DTS package
fromanASP (VB)script and would appreciate any and all respons*e. Idon't even know if it's possible
Thanks
- Chuck Gatto
Dan Guzman May 1 2000, 12:00 am show options
Newsgroups: comp.databases.ms-sqlserver
From: "Dan Guzman" <DGuz...@nospamplease-earthlink.net&g*t; - Find
messages by this author
Date: 2000/05/01
Subject: Re: Executing a DTS Package using an ASP (VBScript) Script
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse
You can specify a trusted connection with flag 256 instead o*f
username and
password. For example:
DTSPk.LoadFromSQLServer ServerName, , , 256,,,,PackageNa*me
Assuming this is an intranet application running under NT 4.*0 and you
want
to execute the package under the invoking user's account, yo*u can do
this as
follows:
Specify 'clear text' for the IIS Directory Security
auth*entication
Remove 'Everyone' from the access list on the files (req*uires
NTFS) and
grant permissions to the users
Grant logins access to the database server
With this method, users must enter their Domain\UserName and* password
when
prompted.
NT authentication presents a challenge when multiple servers* are
involved
because NT 4.0 does not support delegation. See
http://msdn.microsoft.com/workshop/s...e/security.asp for
details.
I understand Windows 2000 provides delegation capabilities b*ut this
can be a
bit tricky to implement.
BTW, if your DTS package does not access SQL Server, you can* save it
to a
file and use the LoadFromStorageFile method instead.
Hope this helps.
If you need to use
Chuck Gatto <cga...@anchorsystems.com> wrote in message
news:8e**********@slb7.atl.mindspring.net...
- Hide quoted text -
- Show quoted text -
Below code works 100% in VB but the load fails in ASP. I* get...
"Microsoft OLE DB Provider for SQL Server. Login failed fo*r user "\".
error. I think the IIS (server a) is set for NT auth. and sql7 (o*n server b) as well but I can't be sure.
Any idea what I should look for.
Thanks
Chuck Gatto May 6 2000, 12:00 am show options
Newsgroups: comp.databases.ms-sqlserver
From: "Chuck Gatto" <cga...@anchorsystems.com> - Find messages by this
author
Date: 2000/05/06
Subject: Re: Executing a DTS Package using an ASP (VBScript) Script
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse
Hey Dan
Thanks again. I really appreciate your input and help.
I actually solved the problem by calling dtsrun...
I apologize for the delay getting back w/you but thee recent* virus
atack
sidetracked me.
Thanks again.
"Dan Guzman" <DGuz...@nospamplease-earthlink.net> wrote in m*essage
news:sg***********@corp.supernews.com...
- Hide quoted text -
- Show quoted text -
You can specify a trusted connection with flag 256 instead* of username and password. For example: DTSPk.LoadFromSQLServer ServerName, , , 256,,,,Package*Name
Assuming this is an intranet application running under NT *4.0 and you want to execute the package under the invoking user's account, *you can do this
as follows:
Specify 'clear text' for the IIS Directory Security au*thentication Remove 'Everyone' from the access list on the files (r*equires NTFS)
and grant permissions to the users
Grant logins access to the database server
With this method, users must enter their Domain\UserName a*nd password when prompted.
NT authentication presents a challenge when multiple serve*rs are involved because NT 4.0 does not support delegation. See
http://msdn.microsoft.com/workshop/s...e/security.asp for details. I understand Windows 2000 provides delegation capabilities* but this can be
a bit tricky to implement.
BTW, if your DTS package does not access SQL Server, you c*an save it to a file and use the LoadFromStorageFile method instead.
Hope this helps.
If you need to use
Chuck Gatto <cga...@anchorsystems.com> wrote in message
news:8e**********@slb7.atl.mindspring.net...Below code works 100% in VB but the load fails in ASP. * I get..."Microsoft OLE DB Provider for SQL Server. Login failed *for user "\". error.I think the IIS (server a) is set for NT auth. and sql7 *(on
server b) as well but I can't be sure.
Any idea what I should look for.
Thanks
chris.duni...@agwsha.nhs.uk Jan 31, 10:05 am show options
Newsgroups: comp.databases.ms-sqlserver
From: chris.duni...@agwsha.nhs.uk - Find messages by this author
Date: 31 Jan 2005 10:05:00 -0800
Subject: Re: Executing a DTS Package using an ASP (VBScript) Script
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
Hi,
I've tried adding this function to my ASP pages and get the *following
error message;
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'DTS.Package'
/asp/pages/dts.asp, line 21
Does anyone have any idea what I need to fix to get the DTS *to work?
I'm v. new to SQL Server and ASP so any help would be apprec*iated.
Many thanks,
Chris Dunigan