When setting up an LCConnection like in the example below one have to put in userid and password in clear text.
Is it a way to set it up so that the agent uses the current users (e.g. in Active Directory) access level to the database source?
Set lccon = New LCConnection("oledb")
.provider = "sqloledb"
.server = "sqlserver"
.Database = "database"
.Metadata = "dbo.personell"
.Userid = "userid"
.writeback = True