Flo,

Which cursor based split solution were you using in those statistics?

Jeff Moden (5/11/2009)

---

UMG Developer (5/11/2009)

---

If you use "|" as a row terminator and comma as the field terminator, it'll import AND SPLIT all of your data all at once all...

Paul White (5/10/2009)

---

We covered the bulk import idea about eleventy gazillion posts back - IIRC we were splitting the text of Moby Dick into words. The basic technique was...

Jeff Moden (5/10/2009)You say you get the data from an Oracle 10 DB... do you mean directly or is it in a text file? Even if it's not in...

Flo,

Yes the data is all text. I'll have to take a look at your proposed solution, but it would need some work to handle all the possible crap data cases....

Because in the source data an individual line may be broken across...

I know I am coming in late, but boy has it been a read so far and I can't wait to see the final outcome.

In the particular problem I am...

ben.rosato (5/7/2009)

I was playing around with this and can't figure out why the "-" in the where clause has to come before all the other individual characters. If I...

Jeff Moden (4/16/2009)

Here's the code...

[font="Courier New"]DECLARE @PrevActualCost MONEY,

        @RunningTotal   MONEY,

        @PrevID         INT

 SELECT @PrevActualCost = 0,

        @RunningTotal   = 0

 UPDATE t

    SET @RunningTotal = RunningTotal = @RunningTotal + ActualCost,

        @PrevID       = ID

   FROM #tmp t WITH (INDEX(0),TABLOCKX)

 OPTION...

Jonathan Kehayias (3/13/2009)

The correct way to do this is to create a SQL Agent Job that runs the SSIS/DTS package, and then start that job using sp_start_job. SQLCLR is...

How about a SQLCLR method to execute a DTS or SSIS package on the server instead of using xp_cmdshell and calling DTEXEC.EXE? (Or is there another way to do that...