sql server dts: Error while executing DTS -- sql server dts

Error while executing DTS

Aparna
9/14/2004 2:30:24 PM

sql server dts:

I ahve created a DTS package & was able to execute it
from backend but while trying to execute DTS Package
created in local Packages in sql client gets error.

Error Number 2147287038T
Error Description :The system cannot find the file
specified.

package Name :FSPETLISASUpload_DevServer1
Code used
set objDTSPackage = Server.CreateObject("DTS.Package")

on error resume next
objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
,
DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
rver1"
Response.Write err.number & err.Description

Thanks in advance

Re: Error while executing DTS

Allan Mitchell
9/14/2004 11:35:06 PM

I would try with this error first

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

--
--

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

[quoted text, click to view]