Folks,

I have a very basic problem. Still I can’t get around it.

1. CSV file need to be loaded daily
2. Each day file is named based on date (i.e. yymmdd.csv)
3. My process goes:
a. ActiveX (loads in Global Variable full path and name of the file that should be loaded that day). It works fine.
b. Then Dynamic Properties Task tries to use Global Variable to specify file that should be loaded from Connection1.
c. Connection1 is source CSV file
d. Connection2 is DB.TBL

Package runs but loads hardcoded file set in Connection1 instead a file specified by variable.

What am I doing wrong. It looks so basic still I don’t see an issue.

Any suggestions … Please!

Forgot to mention workflow details:

‘ActiveX’ On Success ‘Dynamic Property Task’
‘Dynamic Property Task’ On Success ‘Connection1’

It works fine. I figured it out!

I didn’t ‘Refresh’ Packages before I run new version, and it kept on running old solution with hardcoded file.

Thanks anyway - Case Closed.