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 |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2009-01-01 : 21:32:15
|
| Hi all,How can i read file name myexcel12292008.xls automatically. I would like to make it automatically to ready next file next day such as myexcel12302009.xls? How can i sset thtat.thanksPat |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-01 : 22:06:38
|
| Can you elaborate on your requirement? |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2009-01-02 : 08:14:21
|
| I have created SSIS package but i need assistance to read EXcel file automatically for the next day. The file i have is myescel111082008. once that is executed there will be new file myexcel11092008 and so on so i want to read next file automatilly without changing the source manually!!hope that clears something!!thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-02 : 08:15:24
|
| Look for Foreachloop container. |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2009-01-02 : 08:39:47
|
| how can i set that up!! i am totally new to that!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-02 : 09:11:22
|
quote:
Originally posted by PatDeV
how can i set that up!! i am totally new to that!!
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspxhttp://pragmaticworks.com/community/blogs/nayanpatel/archive/2008/11/13/how-to-loop-through-files-in-a-specified-folder-load-one-by-one-and-move-to-archive-folder-using-ssis.aspx |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2009-01-02 : 14:10:31
|
| hi I could do the way they showed but How i can set the package to read file for date such as in the example it shows *.TXT or nightly_*.xls but i want to pass file like file+date.xls(which could be file01022009.xls.Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-02 : 14:13:14
|
| You need to use variables as indicated in the link. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-02 : 14:14:54
|
quote:
Originally posted by PatDeV
hi I could do the way they showed but How i can set the package to read file for date such as in the example it shows *.TXT or nightly_*.xls but i want to pass file like file+date.xls(which could be file01022009.xls.Thanks
If you put .xls extension it will read all files with that Extension .You can move to archive folder as done in link. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-03 : 07:31:58
|
| http://neonlabs.structum.net/blog/?p=235 |
|
|
|
|
|
|
read excel file for import auto