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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 read filename

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.txt

the format is filename_yyyymmdd_hhmm_ss.txt

the 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 ?
Go to Top of Page

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2014-11-20 : 23:14:10
Any step by step guidelines to do this?
Go to Top of Page

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/
Go to Top of Page
   

- Advertisement -