Thanks for your response.

Thinking about it some more, I'm going to convert the values into minutes and hold the elapsed time as integer (sufficient for my purposes).

All the best.

Duncan

Hi, check that the log-in used by the SQL Server Agent has the permissions sufficient for each aspect of the package. We generally use a specifically set-up domain log-in that...

Hi, the only time i have come across this kind of message was when i ran a DTS package as part of a SQL Agent Job. the package included extracting...

Hi, I've had several attempts at doing the same thing as we have customers who use the same cubes and we simply copy the cube from machine to machine.

I have...

The only thing I would add is that if this a regular requirement and the spreadsheets and tables retain the same names before executing the package you can save it....