Try executing the script from the command line or double click in Windows rather than the Task Manager.  If it works then, you have a permissions problem.  Check to see...

You're probably better off maintaining the second license if you go ahead with your strategy of having the secondary work for multiple primaries.  It might be in use frequently, albeit...

If it's available, you might also try consuming this data via Excel, which will "understand" this text file as a comma-separated, quotation-mark-field-delimited file, like this:

DECLARE @SheetFileName VARCHAR(100), 

            @SheetX VARCHAR(150),

            @Err Int

SET...

You got the error from Paul's statement because he typed "%" rather than '%' (double quotes rather than single).  Whether this is going to work or not (I think) depends...

If you're doing the conversion to Julian date in VB code, look here:

http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-2-udf_DT_ToJulian.htm

...as you'll see there, your definition of Julian Date fits only one definition of Julian.  All such...