Hello,
Instead of defining a dynamic property task in each DTS I rather would have
an ActiveX Script task changing the properties of a package.
1. Is this possible?
2. How is it done?
Thanks
Rene

Rene

This is code that I've use to do this. Hope it helps.

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Function Main()
dim pkg
set pkg = DTSGlobalVariables.Parent

dim conOV
dim rs

set conOV = CreateObject("ADODB.Connection")
conOV.Open "File Name=" & DTSGlobalVariables("gvsOneViewLive_Udl").Value
set rs = CreateObject("ADODB.RecordSet")

rs.Open "tblSystemParameter", conOV
rs.movefirst

while not rs.EOF

If rs("ParamName") = "RPT_" +
DTSGlobalVariables("gvsMISEnvironment").Value & "_SAP_Unc" Then
DTSGlobalVariables("gvsSAPFilesUNC").Value = rs("ParamValue")
End If


rs.movenext
wend
rs.close
conOV.close

DTSGlobalVariables("gvsEmployees_UNCFileName").Val ue =
DTSGlobalVariables("gvsSAPFilesUNC").Value &
DTSGlobalVariables("gvsEmployeesFileName").Value

Main = DTSTaskExecResult_Success
End Function

"Rene H" wrote:

Hi Peter
Thanks for the code. I'll try it out. Do you know by any change if the
properties can be altered
by using the Set oAssignment = oCustomTask.Assignments.New?
Regards
Rene

"Peter" wrote: