This is good to generate an initial cut of the SQL code that I will then use at the start of my SSIS package to create the staging tables if...

Just a few things.

1. The script stops coping when the copy from schema comes up as the target, so as written it you would end up with the stored proceure...

You can use a function to reformat the data as a string.

The function could look like

create function MoneyToFixString(@InValue Money)

returns varchar(30)

as

begin

declare @TempValue varchar(30)

set @TempValue = CONVERT(varchar(30), @InValue, 1)

return '$' + substring('...