March 10, 2011 at 9:36 am
Show a simple package that imports a series of flat files. This can be simple 2 column flat files going to a table, but the article should focus on and show
- log the time the import started in a log table for the whole process
- log the time the import stopped in for each file
- log the time the import stopped for each file
- move the imported flat files to an Archive folder
- log the import stop time for the entire process
March 10, 2011 at 9:40 am
You know, I don't do the logging bit, but I do the moving the flat files all the time.
I'll take this one. Learning the logging will be fun. @=)
March 10, 2011 at 10:19 am
The logging can be just inserting rows in a table somewhere. Something easy in your control flow that just adds a step before/after each loop through a file.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply