Executing a DTS Package using an ASP (VBScript)
am 01.02.2005 12:07:24 von chris.duniganI'm looking for an example of how to execute an existing DTS=AD package
from an
ASP (VB)script and would appreciate any and all response. =ADI 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"
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=ADkage from
SQL
Server.
Option Explicit
Const PackageName =3D "PackageName"
Const ServerName =3D "ServerName"
Const UserName =3D "UserName"
Const Password =3D "Password"
Dim DTSPk
Set DTSPk =3D CreateObject("dts.package")
DTSPk.LoadFromSQLServer ServerName, UserName ,Password
,,,,,=ADPackageName
DTSPk.Execute
If DTSPk.Steps(1).ExecutionResult =3D 0 Then
Response.Write "Package execution completed"
Else
Response.Write "Package execution failed"
End If
Set DTSPk =3D Nothing
You can also create the entire package from scratch from wit=ADhin your
asp and
execute it.
Hope this helps.
Chuck Gatto
news:8eapo8$frj$1@slb7.atl.mindspring.net...
- Hide quoted text -
- Show quoted text -
> I'm looking for an example of how to execute an existing D=ADTS
package from
an
> ASP (VB)script and would appreciate any and all response.=AD 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"
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=ADet...
"Microsoft OLE DB Provider for SQL Server. Login failed for =ADuser "\".
error.
I think the IIS (server a) is set for NT auth. and sql7 (on =ADserver b)
as
well but I can't be sure.
Any idea what I should look for.
Thanks
"Dan Guzman"
news:sgi3hi617qo89@corp.supernews.com...
- Hide quoted text -
- Show quoted text -
> This VBScript example loads and executes an existing DTS p=ADackage
from SQL
> Server.
> Option Explicit
> Const PackageName =3D "PackageName"
> Const ServerName =3D "ServerName"
> Const UserName =3D "UserName"
> Const Password =3D "Password"
> Dim DTSPk
> Set DTSPk =3D CreateObject("dts.package")
> DTSPk.LoadFromSQLServer ServerName, UserName ,Password
,,,=AD,,PackageName
> DTSPk.Execute
> If DTSPk.Steps(1).ExecutionResult =3D 0 Then
> Response.Write "Package execution completed"
> Else
> Response.Write "Package execution failed"
> End If
> Set DTSPk =3D Nothing
> You can also create the entire package from scratch from w=ADithin
your asp
and
> execute it.
> Hope this helps.
> Chuck Gatto
> news:8eapo8$frj$1@slb7.atl.mindspring.net...
> > I'm looking for an example of how to execute an existing=AD DTS
package
from
> an
> > ASP (VB)script and would appreciate any and all respons=ADe. I
don'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"
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=ADf
username and
password. For example:
DTSPk.LoadFromSQLServer ServerName, , , 256,,,,PackageNa=ADme
Assuming this is an intranet application running under NT 4.=AD0 and you
want
to execute the package under the invoking user's account, yo=ADu can do
this as
follows:
Specify 'clear text' for the IIS Directory Security
auth=ADentication
Remove 'Everyone' from the access list on the files (req=ADuires
NTFS) and
grant permissions to the users
Grant logins access to the database server
With this method, users must enter their Domain\UserName and=AD password
when
prompted.
NT authentication presents a challenge when multiple servers=AD are
involved
because NT 4.0 does not support delegation. See
http://msdn.microsoft.com/workshop/server/feature/security.a sp for
details.
I understand Windows 2000 provides delegation capabilities b=ADut this
can be a
bit tricky to implement.
BTW, if your DTS package does not access SQL Server, you can=AD save it
to a
file and use the LoadFromStorageFile method instead.
Hope this helps.
If you need to use
Chuck Gatto
news:8ekrkd$pmq$1@slb7.atl.mindspring.net...
- Hide quoted text -
- Show quoted text -
> Below code works 100% in VB but the load fails in ASP. I=AD get...
> "Microsoft OLE DB Provider for SQL Server. Login failed fo=ADr user
"\".
error.
> I think the IIS (server a) is set for NT auth. and sql7 (o=ADn 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"
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=AD virus
atack
sidetracked me.
Thanks again.
"Dan Guzman"
news:sgsfh8spoog87@corp.supernews.com...
- Hide quoted text -
- Show quoted text -
> You can specify a trusted connection with flag 256 instead=AD of
username and
> password. For example:
> DTSPk.LoadFromSQLServer ServerName, , , 256,,,,Package=ADName
> Assuming this is an intranet application running under NT =AD4.0 and
you want
> to execute the package under the invoking user's account, =ADyou can
do this
as
> follows:
> Specify 'clear text' for the IIS Directory Security
au=ADthentication
> Remove 'Everyone' from the access list on the files (r=ADequires
NTFS)
and
> grant permissions to the users
> Grant logins access to the database server
> With this method, users must enter their Domain\UserName a=ADnd
password when
> prompted.
> NT authentication presents a challenge when multiple serve=ADrs are
involved
> because NT 4.0 does not support delegation. See
> http://msdn.microsoft.com/workshop/server/feature/security.a sp for
details.
> I understand Windows 2000 provides delegation capabilities=AD but this
can be
a
> bit tricky to implement.
> BTW, if your DTS package does not access SQL Server, you c=ADan save
it to a
> file and use the LoadFromStorageFile method instead.
> Hope this helps.
> If you need to use
> Chuck Gatto
> news:8ekrkd$pmq$1@slb7.atl.mindspring.net...
> > Below code works 100% in VB but the load fails in ASP. =AD I get...
> > "Microsoft OLE DB Provider for SQL Server. Login failed =ADfor user
"\".
> error.
> > I think the IIS (server a) is set for NT auth. and sql7 =AD(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 =ADfollowing
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 =ADto work?
I'm v. new to SQL Server and ASP so any help would be apprec=ADiated.
Many thanks,=20
Chris Dunigan