Here is something very quick that will check for every SQL Server connection
if the connection is set to use a Trusted connection

Function Main()


dim cn

for each cn in DTSGlobalVariables.Parent.Connections
if cn.ProviderID = "SQLOLEDB" then
if cn.ConnectionProperties("Integrated Security").Value = "SSPI" then
' Do Something
End if
End if
next


Main = DTSTaskExecResult_Success
End Function


--
--

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


"Rev" <Rev (AT) discussions (DOT) microsoft.com> wrote

how to create packages programatically, and even a few on retrieving
properties. The problem is the property I need is specific to the
connections in the task. Can anyone please help?