I've a dts that needs an explicitly defined argument.
I'm looking for both some kind of interactive 'input box' that lets the user
type the needed argument and some kind of launch parameter similar to the
ones that EXE file get.

I'm not interested in ini-files parameters.
Thanks in advance

Agostino

OK whilst you can get an InputBox through DTS I would probably not do it.
The reason is if you cause a lock or block then it will be waiting until you
press a button. I would probably have the application calling DTS pass in
the values after asking the user for the value outside of the package. You
can then either call the package through the object model or you could call
it on the cmdline passing a value to the /A switch





"Agostino" <agostino_sclauzero (AT) hotmail (DOT) com> wrote

Ok, i'll go the object model way through dts com object 'package'.
By the way, is there a way to obtain the list of packages published on a
certain SQL Server?
Thank you for your help
Agostino

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> ha scritto nel messaggio
news:#Eb9AsJrFHA.2064 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

You can look directly in sysdtspackages (msdb) or you can look at somthing
like this

Dim oApplication ' As DTS.Application
Dim oPackageSQLServer ' As DTS.PackageSQLServer
Dim oPackageInfos ' As DTS.PackageInfos
Dim oPackageInfo ' As DTS.PackageInfo


Set oApplication = CreateObject("DTS.Application"*)
Set oPackageSQLServer = oApplication.GetPackageSQLServ*er("(local)\dev", "",
"", 256)


Set oPackageInfos = oPackageSQLServer.EnumPackageI*nfos("", False, "")


Set oPackageInfo = oPackageInfos.Next
Do Until oPackageInfos.EOF
Wscript.Echo(oPackageInfo.Name*)
Set oPackageInfo = oPackageInfos.Next
Loop


Set oApplication = Nothing






"Agostino" <agostino_sclauzero (AT) hotmail (DOT) com> wrote