November 12, 2013 at 1:25 am
Hi,
(Sql Server 2008 / VStudio 2008)
it is easy to configure DB-connections - ServerName and Initial Catalog
but how to accomplish the same with 'Foreach File Enumerator'?
that is:
Enumerator configuration
Directory: \\servername\sharename\folder
Files: SalesData*.csv
If this not possible, do I need to skip the container and always have the files named with specific names?
(I could just use \\localhost above and no configuration xml entry to handle test/prod environments but the customer also wants to run SSIS from personal laptops...)
Ville
November 12, 2013 at 4:21 am
You have several ways of doing that, but one would be to configure your loop to use Expressions for FileNameRetrieval and Directory.
Base those expressions on variables and set the variables' values through the config file
Voilà 🙂
November 12, 2013 at 4:33 am
Where do you fin fthese? Expressions for FileNameRetrieval and Directory
I don't see them in the Expressions part of the container...
v
November 12, 2013 at 4:40 am
See attachment
November 12, 2013 at 4:44 am
Yes!
I was looking after them in the wrong expressions menu:
General
Collection
Variable Mappings
Expressions
Thanks,
V
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply