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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-10-22 : 10:18:16
|
| Hey Guys,I have to load few files everyday... I need help on onething.. filename will be Ex. individual_20091022.txt What I need to do is assign the filename in some variable and then use that variable to update a Log-Table and then load that file and update the Log-Table once again after the file is loaded. This is my first package and has never done the scripting task... Thanks guys for the help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-22 : 12:50:16
|
| have a look at thishttp://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2009-10-22 : 14:23:48
|
| Visakh nice... thank U this helps. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-23 : 12:37:32
|
| welcome |
|
|
|
|
|
|
Script Task Help