Hi all,

I am kind of new in this topic and get stuck for awhile. I migrated DTS
packages from SQL Server 2000 (Windows 2000) to be SSIS packages on SQL
Server 2005 (Windows 2003 Server) but don't know how to modify ASP code to
run SSIS on a local machine.

The current web application uses an ASP script to run a DTS package.

The ASP codes are like this:

Set dtsPackage = CreateObject("DTS.Package")
dtsPackage.LoadFromSQLServer "MyServer", "MyUser", "MyPassword",
DTSSQLStgFlag_Default,"PackagePassword","","","MyP ackage"
dtsPackage.Execute

If anyone has experience with this, could you please advise?

I googled to search for an answer but have not found anything yet.

Really appreciated your help. Thanks in advance!