Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Error in Sql Server DTS through ASP Page

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-19 : 11:22:39
Puneet writes "Hi I am stuck with a problem. My DTS Package is password protected and I want to execute it thru the ASP Page Can Anybody tell me the right script for that
I tried and I am getting a error like:

""""
VBScript Errors Occured!
Error Number= #-2147220499
Error Desc.= No Steps have been defined for the transformation Package.
Help Context= 700
Help File Path=sqldts80.hlp
Error Source= Microsoft Data Transformation Services (DTS) Package
"""""
I think this problem is occuring because of the dts password protection. As while executing it through script I didnt give its password but I also dont know where to give the password in the script..And the script is running absolutly fine on my local server...

I am not been able to sort it out. Can anybody help me for that.
Thankx.."
   

- Advertisement -