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 |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2003-01-23 : 14:05:37
|
| I have a directory with 10 logfiles that are created by IIS. The names are always different. IS there a way that I can have a package grab each file out of that directory and then do its job on it?As it is right now, all I can do is grab one file at a time.This is SQL 2000.Thanks |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-23 : 14:15:14
|
- Build a table T1 in a database with the names of the files
- Build a package P1 that has a global variable for file name. Use A Dynamic Properties Task to set the Datasource for you Text File from the global variable.
- Build a package P2 that iterates through your table T1 and passes the file as a parameter to package P1
EDIT: or better yet ... http://www.sqldts.com/default.aspx?6,103,246,0,1Jay White{0}Edited by - Page47 on 01/23/2003 14:18:00 |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2003-01-23 : 14:22:26
|
| That link is a very good example. ThanksOne more thing...IS there a On Error Resume Next type of error handling in packages so that if it encounters an error it just continues? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-23 : 14:54:00
|
| Just use the on completion workflow item. |
|
|
|
|
|
|
Packages and Multiple TextFiles