Please explain - why are you using SSIS, when it seems that you are executing only T-SQL?

Alvin Ramard (8/31/2010)

---

If I understood correctly what you're doing, I think you'll have to pass the resultset to a ForEach Container which contains you backup task. Inside the forEach...

Good luck!

Got to love those German error messages 🙂

OK, I think you are on the right track though - you just need to know what format to pass in the list...

Can you expand on "it does not work" - post error messages please.

Also, you may think it's obvious, but it makes things easier for people reading if you explicitly state...

Or you could embed some code in an Excel spreadsheet and (maybe) use this blank worksheet as a template.

The SSIS process populates the spreadsheet template with data and when the...

Yeah I know that - but what's important is the name of the sheets in the specific Excel sheet that you are accessing in your package.

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...