CAN I USE A VARIABLE FOR THE 'SOURCE' SIDE OF A TRANSFORMATION?

[PrgrmsAll]

In my DTSPackage, I have an Excel to SQLServer transformation. The Excel component specifically identifies the Excel workbook to be used. However, this is a soft source in that the file name changes month to month.

How can I handle this in the DTS since the Excel module requires me to specify a file?

I have written an ActiveX component that will go to the directory, determine the file name and write it to a Global Variable.

Any assistance/pointers/advice is greatly appreciated.

 

[MDXer]

use Dynamic Properties to assign the source name. You need to populate the file name using the GV.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck