When I try to execute the DTS package from ASP Page , it
gives the follwing error:

0-2147220440Package failed because
Step 'DTSStep_DTSDataPumpTask_1' failed.


But it runs fine from EM

Thanks in advance.

Make sure your not using Windows Integrated Security in your package unless
your impersonating users in your asp application...

"Aparna" <nandi_aparna (AT) yahoo (DOT) com> wrote

Can U pls explain it in detail.
Thanks,Aparna

In article <352401c49d00$3df0f960$a601280a (AT) phx (DOT) gbl>, Aparna wrote:
The error suggests that the datapump fails and because you are calling
the package from ASP then it suggests the security account with which
you are connecting to the datasources in your package is set to use
Windows authentication and that this then uses the ASP account.

http://support.microsoft.com/?kbid=252987

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.konesans.com - Consultancy from the people who know

I am using udl files for datasource connectivity
for the package and it is not using windows
authentication.Also removed windows integrated
authentication checkbox from iis.Still Failing