Hello!

I'm trying to execute my VB Package from a VB script. My code is :

dtsPackage.LoadFromSQLServer _
ServerName:=gs_ServerName, _
ServerUserName:=gs_UserName, _
ServerPassword:=gs_Password, _
PackageName:=gs_PackageName

But I cannot find what is the gs_UserName and the gs_Password. Where
can I find it ? I have search in the properties of the server but did
not find.

Thanks for your help

Al

The UserName and Password are your logon credentials to the server you
specified in ServerName

have a look here

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208,1)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Al" <alhoffmann (AT) free (DOT) fr> wrote