Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exeucte a SQL DTS Package from MS Access
- Thread starter Cloonalt
- Start date
- Thread starter
- #2
This code works for me and I'll share it here:
Const DTSSQLStgFlag_UseTrustedConnection = 256
Dim dtsp As New DTS.Package
Dim pkg As DTS.Package
Set pkg = New DTS.Package
pkg.LoadFromSQLServer "ServerName", , , DTSSQLStgFlag_UseTrustedConnection, , , , "Daily_Import"
pkg.Execute
Const DTSSQLStgFlag_UseTrustedConnection = 256
Dim dtsp As New DTS.Package
Dim pkg As DTS.Package
Set pkg = New DTS.Package
pkg.LoadFromSQLServer "ServerName", , , DTSSQLStgFlag_UseTrustedConnection, , , , "Daily_Import"
pkg.Execute
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question