Check out the DelimitedSplit8k function here:

http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589

It'll do exactly what you need.

Brandie Tarvin (10/28/2010)

---

GilaMonster (10/28/2010)

---

Brandie Tarvin (10/28/2010)

---

AWESOME! Time to start watching some...

Jay-45986 (10/28/2010)

---

Beautiful 🙂

I can actually see it getting fired off!

One problem though - it was only inserting the last record of the batch. So I did some googling, and...

Are you getting this error when you schedule the package via a job and were successful from BIDS/VisStudio, or are you getting this from Visual Studio directly before a deployment...

Wayne, they're looking for last data modify.

Which might work, if all the fields are in an index. But afaik (assuming we CAN find the last modified date) even the...

I didn't want to use creation time because runtimes may be a bit wild. ...

There, found what I was looking for. Thank you for that url Raunak, was the missing link for me. 🙂

Final code (functional and tested):

...

Awesome link, thanks, exactly what I was looking for. With a little puzzlement, I've figured out how to get it to do what I want (I think).

However,...

Shame you can't have those two links just be immediately clickable...

So, you want fresh topics in that forum, rather then responses to the pinned topic? Just confirming from what I see. When I read the pinned item it...

Check out this article:

http://msdn.microsoft.com/en-us/library/ms141237.aspx

In particular, this section:

In addition to the fast load options exposed in the OLE DB Destination Editor dialog box,you can configure the OLE DB destination to use...

That looks right to me... I assume that's a simplified trigger for our benefit.

Some things can ignore triggers, like Bulk Insert has the ability to turn it off. ...

Under 99% of circumstances, you'd run the procedure via a query window.

Example, if you made this proc:

CREATE PROC AlphaProc

(@blah INT = NULL)

AS

SELECT @blah

You would run it for different variables like...

Steve Jones - SSC Editor (10/27/2010)

---

Hmm, me too. What were the titles? We have a versioning system and they may have been superceeded. Or dropped. Things below 2k or so...

Steve, I did a search (honestly, a brief one) about basic troubleshooting/optimizations for queries that I think would save a lot of headaches if I could just link some folks...