jreece (5/17/2010)

---

Gaurav,

He left out some important details about the inner loop. That one should be configured as a Foreach File Enumerator, not and ADO enumerator. The rest of...

You'll need to add an expression to the Excel connection manager. ExcelFilePath is the expression you'll need to look for. You'll need to include the full path of...

I used an onError event handler to mark the flag back to 0. In the event that I couldn't connect to the database, I have a job that will...

You could add a step at the beginning of the process to set a flag in a table to 1 and set it back to 0 once it's completed. ...

Personally, learn both as much as you can. There are some tasks you can do with native SSIS tasks but some tasks like the file system task can be...

Quite honestly, I can never get the file system task to work the way I want it to so I wind up using a script task instead and pass in...

I guess what has be a bit...

We average about 2300 records per hour. However, they are not equally distributed across the hour. We get them in short bursts of 100 or so records.

What do the logs on the AS400 say?

I think Mike hit it on the head. It's an insurance policy. You'll like won't use it but if you every have an issue you can always go...

You're right. I misread the requirement. I think you could still do directory.delete(some sort of path))

I would still consider trying the for each file enumerator along with a script task. I've deleted thousands of files in just a few minutes. The first time...

Under the squiggly line it will usually tell you what it can't set the variable. What does it say?

There is a property in the execute process task called successvalue. It sounds like you have it set to 1 instead of the default of 0.

You could always just add a column to your table with a default value of getdate().