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 |
|
vamsimahi
Starting Member
29 Posts |
 Posted - 2008-09-10 : 14:54:05
|
| Hi,I have few .csv files in a folder. Those files have data which need to be exported to a table in SQL server. The file names are in the form of YYYYMM (i.e., 200809 , 200808, 200807...). A new file is created at the beginning of each month. I need to create a process that determines the most recent file in the folder and load that plus the previous 11 files data into the SQL. I think I can use a script task and for-each loop container for the SSIS package... |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-09-30 : 22:41:40
|
| your apprioach is correct; user script task and for each loop conatiner |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-30 : 22:56:02
|
| You may want to look this one:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110326 |
|
|
|
|
|
|
load csv files to SQL...using file name