Art,

I know this post is after the fact, but I thought I would put in my two cents in case someone else views this thread....

You can use the following to achieve what you are looking for:

=Format(DateAdd("s",12600, Today), "hh:mm:ss")

12600 would be the number of seconds from your database and in this case would result in...

There are some additional options for writing to a text file from T-SQL that require less system resources and are quicker to set up. These options involve using the...

I just wanted to add that you do not need to put all control flow tasks from your package into a Sequence Container in order to use the Event Handling...

I know this is a SQL Server Forum, but as an alternative, you can also call off the package from .NET. Our company had a very similar requirement

in that...

You would need to include your tasks in a container such as the For Loop, ForEach Loop or the Sequence Container. These containers have a "Transactions" section in the...

You can ignore my post - I didn't realize there was a second page and someone had already provided a set-based solution.

Bob

I know that this is an old post, but I have the set-based solution you are looking for. I created a temp table to enter the values you had...