Great - and the answer to the first question?

Please excuse the obvious question, but is there a worksheet called Sheet1 in the workbook being accessed?

What version of Excel are you using?

Are you working in a 32- or 64-bit...

Please post the full text of the error message.

What problems are you having?

Is the format of all the worksheets the same (column order, datatype etc)?

An easy way round this to set a package variable within your script task and then use precedence constraints to direct the flow afterwards based on the contents of the...

That sounds overly complex to me. If a package is scheduled to run every x minutes, can't it just calculate the time between the last log entry and 'now' and,...

I was thinking along similar lines, but with a different slant: automate Excel to output the data to CSV and then use that CSV as the SSIS data source.

OK, maybe I understand your problem. You want to know how to get just the time bit into a datetime variable?

You can't do that, but you could put a dummy...

SQL trance files eh? Whatever would Freud say? 🙂

See my reply post to another thread of yours regarding time comparisons - no trouble really.

It's a puzzle that would probably be sorted out within five minutes if an experienced SSIS user had direct access to the package. I have nothing specific to add that...

The original post contains the following:

I Configured a...

Ball-and-socket works for me every time.

Oh hang on, I'm wrong, that's a joint. Which is what you lot have been smoking, by the looks of things 🙂

Interesting thread guys, thanks for all the info.

AndrewSQLDBA (8/24/2010)

---

Phil

What about instead of the file timestamp of a date and time, I want to use only the time. Is there a way to strip off the date and...

AndrewSQLDBA (8/24/2010)

---

Will not work

The file names change daily.

I want to copy only the files that are created between a certain time of day. Say between 1:30 PM and 2:00 PM

No...