| | Introduction
Some day before in my article we learn how to make dts package in here
Technologies
SQl server
Prerequisite
SQl server 2000, Later versions
Implementation
Take one ActiveX Script in DTS Package and put following code in main function like
{codecitation class="brush: vbscript; gutter: true;" width="650px"}
Function Main()
main = DTSTaskExecResult_Success
Dim oPkg, oStep
Dim sServer, sUID, sPWD, iSecurity, sPkgPWD, sPkgName, sErrMsg
Set oPkg = CreateObject("DTS.Package")
' Assign parameters
sServer = "SqlserverName"
sUID = "UserName"
sPWD = "password"
iSecurity = DTSSQLStgFlag_UseTrustedConnection
sPkgPWD = "DtsPackage password"
sPkgName = "DTSPackageName"
' Load Child Package
oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity, sPkgPWD, "", "", sPkgName
' Execute the Package
oPkg.Execute
End Function
{/codecitation}
Conclusion
We can execute dts Package easily using Script. we can also execute more then one DTS package sequentially using script.
Enjoy!!!!!!
Happy Programming.
| About the Author |
 | | Kirti Darji | P.G.D.C.A, M.SC(Computer Science) 3+ YEAR EXPERIENCE Visual C#.net and VB.net Windows and Web base Application
Expertise :C#.net, VB.Net,ASP.net,SQL Server, MS Access,aJAX, JavaScript,CSS,HTML,XML,N TIRE ARCHITECTURE,oOPS,Web Services,Core Ajax,visual Source safe,IIS
Occupation :SR. Software Developer
Company : MADHUVAN INFO TECH PVT.LTD
Location :AHMADABAD
|
|
| |