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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-08-29 : 07:18:28
|
| I have a crazy question hopefully someone has had to do this before. I have to read in multiple files from multiple vendors. I would like to know who sent what, when and how many recs by storing the filename (which has a date stamp). Is there a way in SQL Server to store the filename as the files are read?Not sure if anyone has faced this problem before and if so what they did about it. I told you it was a crazy question. Any input is welcome.Thanks much,Trudye |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-29 : 08:22:38
|
| try with SSIS script task to get filename. |
 |
|
|
Trudye
Posting Yak Master
169 Posts |
Posted - 2008-08-29 : 16:00:04
|
| Thanks visakh16 for responding. I wish I knew enough .Net to accomplish the task. Maybe I'll play around with .Net and see what I come up with. Thanx again,Trudye |
|
|
|
|
|
|
saving filenames in SQL Server