May 19th, 2004, 07:48 AM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
master-dts - doesn't work
Hi
I try to create a "master-dts" which calls a lot of other dtss. (MS SQL 7.0)
I use an ActiveX Script Task .
If I use it local, than its ok. But if I use it with dtsrun, then I get error 80074005 "unspecified error"
I think, that the sub-dts-package try to runs on the wrong server.
Any ideas?
thanks steffi
sorry for my bad english
ActiveX:
Quote:
' 205 (ExecPkgFromPkg)
Option Explicit
Function Main()
Main = DTSTaskExecResult_Success
Dim oPkg, oStep
Dim sServer, sUID, sPWD, iSecurity , sPkgPWD, sPkgName, sErrMsg
Set oPkg = CreateObject("DTS.Package")
' Assign parameters
sServer = "server"
sUID = "sa"
sPWD = "******"
iSecurity = DTSSQLStgFlag_UseTrustedConnection
sPkgPWD = ""
sPkgName = "sub_dts_package"
' Load Child Package
oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity , sPkgPWD, "", "", sPkgName
' Execute the Package
oPkg.Execute
' Now check for errors in the Child Package
For Each oStep In oPkg.Steps
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
Main = DTSTaskExecResult_Failure
End If
Next
' Clean Up
oPkg.Uninitialize
Set oStep = Nothing
Set oPkg = Nothing
End Function
|
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
