Here's a solution I found when writing xml files

Create a script task passing in your xml string as a variable (along with any file names etc). Add a reference to...

Or you could just forget doing all the formatting yourself and use the msdb sys function dbo.agent_datetime(@date int no default,@time int no default)

so to get the run date and time

...

Here's a really simple solution to the problem

create procedure StringToMixedCase

 (

  @str varchar(255) OUTPUT

&nbsp

AS

Declare @space smallint

--Add Space to start to aid in the change

SET