master-dts - doesn't work - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

master-dts - doesn't work

Author

Topic

steffi_ma
Starting Member

1 Post

Posted - 2004-05-21 : 04:32:20

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 run on the wrong server.

Any ideas?
thanks steffi
sorry for my bad english

ActiveX:


' 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

rushdib
Yak Posting Veteran

93 Posts

Posted - 2004-05-21 : 08:48:53

Steffi, we use SQL Server 2000, so I am not sure whether the DTS is different in SQL Server 7.0
Are all of your child packages working successfully?
The other thing is I use the GUI to create the packages, and I didn't have any problem on Master-child package situations.

Rushdi

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-05-21 : 08:57:26

Have you got the correct permissions to run this? Do you log onto the server as yourself to run it there? What permissions are set for the SQLAgent account?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources