Visual Basic Syntax

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL DTS

anuradhat

2005-08-03, 4:02 am

Dear Friends

How can I execute a SQL DTS using vb6?

Thanks

Anuradha

Jeff Johnson [MVP: VB]

2005-08-03, 5:06 pm

"anuradhat" <anuradhat@lankaequities.com> wrote in message
news:eo4uKt$lFHA.3316@TK2MSFTNGP14.phx.gbl...

> How can I execute a SQL DTS using vb6?

Assuming you're connecting to the server via Windows authentication:

Dim pkgDTS As DTS.Package

Set pkgDTS = New DTS.Package
With pkgDTS
.LoadFromSQLServer strServer,
Flags:=DTSSQLStgFlag_UseTrustedConnectio
n, PackageName:=strPackageName
.Execute
.UnInitialize
End With

Sponsored Links