I have created a DTS package with 3 steps. When I execute the package from
within Enterprise Manager the package executes successfully. However when i
run the package from within the asp page I get an error on the 3rd and final
step.

Executing shipTableTitles from sqlServer1

Step [DTSStep_DTSExecuteSQLTask_1] succeeded
Task "Drop table titles"

Step [DTSStep_DTSExecuteSQLTask_2] succeeded
Task "create table tblTitles"

Step [DTSStep_DTSDataPumpTask_1] failed
Task "Transform Data Task: transfer tblTitles"

Package [shipTableTitles2] failed

Done

Any help would be great.

Thanks

~Brian

Probably permissions

have a read here

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Brian Wagerer" <bwagerer (AT) compuwiztech (DOT) com> wrote

Thanks, butIi have been to this page. This is where I leared how to use asp
to execute the dts. The thing is thedts runs 2/3 and then fails.


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

Fails with what though?
Can you log the errors?
Fail the package on the first error.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Brian Wagerer" <bwagerer (AT) compuwiztech (DOT) com> wrote

It is still probably permissions. If running directly from ASP then does the
IWAM account have access to the source and destination for "Transform Data
Task: transfer tblTitles"?
In that article it discusses using a VB COM object to abstract the execution
security context away from ASP, as very often the ASP context does not have
sufficient permissions to access the resources used in the package, and nor
would you want it to.


--
Darren Green
http://www.sqldts.com

"Brian Wagerer" <bwagerer (AT) compuwiztech (DOT) com> wrote

Here is some of the log about the error.

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Step Error code: 80040E4D
Step Error Help File:
Step Error Help Context ID:0

Thanks
Brian




"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote