Creating a DF with variable table names
I have a need to create some data flows that use a varying input table name. The structure remains the same from month to month, but the underlying ERP system creates a unique, but easily deduced, name for the transactional table every month. I know I can create a script that can assemble the name of the table each month at the WF stage and assign it to a variable, but is it possible to pass this into a DF to make it use that name as the source table?
I am using Data Services XI 3.0 on Windows running against a Storis system (retail ERP running on UniData DB).