Executing a DTS from another DTS... | 23 Feb 2010 01:02:51 |
| | hi All Expert
script for
Executing a DTS from another DTS...
call dts package for Another DTs Package nested dts packages
Regads
Kirti Darkji | |
| | | |
| Re:Executing a DTS from another DTS... | 23 Feb 2010 01:02:51 |
| | Hi
I think you can use the DTSRUN.EXE to run.
[url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1273819,00.html[/url]
Thank you | |
| | | |
| Re:Executing a DTS from another DTS... | 23 Feb 2010 01:02:51 |
| | Using Scripting Done
[code]
Dim oPkg, oStep
Dim sServer, sUID, sPWD, iSecurity, sPkgPWD, sPkgName, sErrMsg
Set oPkg = CreateObject("DTS.Package")
sServer = "ServerName"
sUID = "Username"
sPWD = "Password"
iSecurity = DTSSQLStgFlag_UseTrustedConnection
sPkgPWD = "Passworddts"
sPkgName = "PackageName"
oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity, sPkgPWD, "", "", sPkgName
oPkg.Execute
[/code]
Happy Coding
Regards
Kirti Darji | |
| | | |
| Re:Executing a DTS from another DTS... | 23 Feb 2010 01:02:51 |
| | | | |
|