Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2010-11-11 : 14:40:21
|
| Is is possible to create an Excel Connection Manager without hardcoding the Excel File Name or referencing it in a config file?I want to point to a directory that will contain the Excel file.The problem is that each month, the file in this directory will have a new date appended to it. SSIS expects you to point to a named file, not just the path to it.Has anyone done something like this using Expressions, perhaps in the ExcelFilePath property? |
|
|
AF
Starting Member
7 Posts |
Posted - 2010-11-15 : 09:45:45
|
| Looks like you want to use a foreach loop... i'm battling with them at the moment (and only came here to ask my own questions!) so can't give you any more specific help but you can find some details here - http://technet.microsoft.com/en-us/library/ms345182.aspx |
 |
|
|
|
|
|
Excel Connection Manager with Changing File Names