I solved it with SQL.Dmo
- From: "Geri Reshef" <GeriReshef@xxxxxxxxx>
- Date: Thu, 26 Jul 2007 16:55:42 +0300
Function Main()
Dim Cn, RS, F
Set Cn = CreateObject("SQLDmo.SqlServer")
Cn.LoginSecure = True
Cn.Connect "(local)"
Set RS=Cn.Databases("LTSB").ExecuteWithResults("Select ... From ... Where ...")
F = RS.GetColumnString (1,1)
..
..
..
Main = DTSTaskExecResult_Success
End Function
- Prev by Date: Re: storing password in SSIS
- Next by Date: Re: SSIS - can SSIS pkg recognize a drive letter within SMS job?
- Previous by thread: Re: storing password in SSIS
- Next by thread: Limiting Log Growth during DTS Package
- Index(es):