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 |
|
kranthiblogs
Starting Member
5 Posts |
 Posted - 2011-04-20 : 14:56:38
|
| am having a 'for each' loop, which loops throw all the files in a specific folder and then performs few business..--> i need to Read the file name and needs to insert in to a table... |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-05-06 : 11:30:08
|
| Inside the for each loop,add a script task to read the file store in a variable then take execute sql task to read the value from the variable to write to table using insert statement it works.if you have problem facing with writing script to read name of the file.I have code that might help.If u need it. |
 |
|
|
|
|
|
How can i get file name, while reading a file