I have a DTS package called MY_package which executes w/o wnay error if i execute it manually through the wizard.But If i try to load the following page no any data are imported. I am trying to import Acess data to MS SQL server 7.0.<BR>Dim objPkg, strError, iCount <BR><BR> &#039;Create and Execute the package<BR>Set objPkg = Server.CreateObject("DTS.Package")<BR>objPkg.LoadF romSQLServer "server2002", "sa", "", _<BR> DTSSQLStgFlag_Default,"","","","My_package"<BR> objPkg.Execute<BR> <BR> &#039;Check For Errors<BR> For iCount = 1 To objPkg.Steps.Count<BR> If objPkg.Steps(iCount).ExecutionResult = DTSStepExecResult_Failure Then<BR> strError = strError + objPkg.Steps(iCount).Name + " failed. " + chr(13)<BR> End If<BR> Next<BR> <BR> If strError = "" Then<BR> Response.Write "Success"<BR> Else<BR> Response.Write strError<BR> End If<BR><BR> Set objPkg = Nothing<BR><BR>*******************************<BR> I even get the success o/p ...what am i doing wrong??I have saved teh DTS on SQL server. Any help wpuld be greatly appreciated.