June 25, 2008 at 4:41 pm
We are in the process of migrating scheduled DTS packages from a SQL 2000 server to a SQL 2005 EE server. We are receiving the following or similar log files on DTS packages when a task is set to transfer files. The SQL Server Agent (MSSQLSERVER) has been set with a Domain Account with appropriate permission set to the receiving share and the package will work manually. In addition, the vbscript is is referencing has appropriate Source changes (Any thoughts would be appreciated):
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
Error on Line 20
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
Error Detail Records:
Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
Error on Line 20
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2
DTSRun: Package execution complete.
June 28, 2008 at 11:14 pm
[font="Verdana"]Make sure SQLAgent account has necessary permission in the share folder!
If you are having legacy package of SQL 2000 DTS then copy that DTS to a folder and then make use of dtsrun.exe to execute the package.
eg.)
DTSrun.exe /F D:\dts_package.dts[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply