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 |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2014-11-20 : 22:48:09
|
| I have txt file format like this Example_20141120_1800_29.txtthe format is filename_yyyymmdd_hhmm_ss.txtthe file to be placed has different time, how to apply the expression in ssis to read the file push to table?i able to apply the file with the filename and datetime. but my issue here is i wouldn't know the exact datetime.any way to apply LIKE in ssis expression? |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-11-20 : 22:56:16
|
| Did you try FOREACH LOOP CONTAINER ? |
 |
|
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2014-11-20 : 23:14:10
|
| Any step by step guidelines to do this? |
|
|
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2014-11-23 : 22:25:55
|
| http://sqlserverrider.wordpress.com/2013/01/07/dynamic-file-name-for-excel-connection-manager-ssis/ |
|
|
|
|
|
|
read filename