LOL :laugh:

a motorbike ashtray!!!

Thanks, Phil. I needed that this Monday morning!

Brandie,

I thought we were talking SSIS.

A ForEachLoop populating a variable with a complete UNC path.

like: "\\SourceServer\ShareFolder\DB1\DB1_db_200812011600.bak"

Try this....

Open a package in BI, (SSIS).

create a variable, 'SourcePath' as a string with...

Brandie,

Does the "DiffShareFolderName" have any relation to the source "ShareFolder"?

The following expression code will pull just the file name from the complete filepath in your variable.

This can be placed in...

Hey Brandie,

I have used the following ConnectionString expression in my destination connector to ADD a folder and date to a file name:

SUBSTRING( @[User::filename],1, FINDSTRING( REVERSE(@[User::filename]) , "\\", 1 ) )...

In the Precedence Constraint editor, set the Multiple constraints to Logical OR.

I've had this issue with translating JDEdwards dates running on an AS400.

JDEdwards date format is: CYYDDD

Had to import as datatype(INT) and used a function to translate.

The answer would be Nested foreach loops.

Build a foreach loop for a single folder in a variable, with the data transformations, then place that inside another foreach loop that loops through...

David,

Look at the Pivot data transformation.

Ron

If your output file format is the same , or at least managable,(say 3 or 4 different formats) I think i would:

1. create a table with the dynamic variables info. (storeID, ProductID, filenames,...