This might work as a different approach. Comments before the CREATE statement might give wrong results, but should work better than your previous option.

SELECT STUFF( definition, CHARINDEX('CREATE ',definition), 6, 'ALTER')...

Even with SSIS, I'm not sure that formatting is possible without some code on a Script Task.

Another way to do it is by creating a Macro in Excel and run...

As you're reading all the rows from YTD, I guess a single scan should perform better.

Be sure not to get lost on what this is doing. Since you're using 2008,...

You should read about aggregate functions. There are many places to read, but you can get a quick start by using the Stairway to T-SQL DML on this site[/url].

Your query...

Sean is using cascading CTEs to create a tally table. A tally table allows you to work with rows that are numbered.

In this case, Sean included 100 000 rows...

No, neither the ORDER BY for window functions.

But the Quirky Update is supposed to be even faster. For more information: http://www.sqlservercentral.com/articles/T-SQL/68467/

Go to the parameters tab on the source and destination objects (not the connections) and define names for the parameters. If I remember correctly (as I don't have SSIS right...

Are you using parameters for your source query?

And here I was trying to figure out how to keep the posted order.

CREATE TABLE #Test(

ID int IDENTITY(1,1),

Name varchar(20),

...

mar.ko (9/3/2015)

---

No excuse on Microsoft's part....should have...

You could use cross tabs to create the recordset with the help of the ranking functions.

I'm not in the mood of creating the whole scenario, but it can certainly be...

halifaxdal (9/3/2015)

---

The import process took less than half an hour and complete like an amazing miracle, and with no error even for the last line.

Thank you very much Luis for...

halifaxdal (9/3/2015)

---

Luis Cazares (9/3/2015)

---

halifaxdal (9/3/2015)

---

I found the issue:

The data row contains comma in one of the column, which makes the bcp thinking it is a delimiter.

Maybe I need to re-generate...

Not really strange as it converts to an int within the IIF before being converted to a bigint.

I would try a different approach knowing the problems caused by ISNUMERIC[/url].

CREATE TABLE...

I'm starting to hear some crickets. 😀