Can you detach them? That should allow you to delete them.

What have you tried?

Bummer but it looks like it can't be done directly using SSIS...it needs some pre-processing:

http://www.sqlservercentral.com/Forums/FindPost888553.aspx

Ditto. We have a hard enough time with keeping...

Here is a slight variation which will protect you against new "type" values added to your database down the line from altering your expected results:

Yours (re-formatted):

SELECT b_id,

...

I think you need to surround the path with double quotes because it has a space in it...something like this:

Google is your friend.

http://stackoverflow.com/questions/997628/how-do-i-increase-the-maximum-allowed-attachment-size-for-email-sent-using-msdb-d

Is this for Oracle? What is VARCHAR2(7 BYTE) ?

Indexes? Keys?

JKSQL (5/12/2011)

---

It is .Net but the problem I have is we are forced to code to 2005 and greater. That means my TVP is a CSV. They are...

sturner (5/12/2011)

---

Well here are two concrete reasons why not to do it the way they are doing it:

1) Performance: there is a overhead associated with each batch, from the network...

JKSQL (5/12/2011)

---

The developers I am working with are taking to the idea of stored procedures which is great. Problem is now they seem to be sending batches of stored...

Here's a solution using CROSS APPLY that builds off Dixie's idea but does not require an aggregate table to be maintained. It seems to perform well compared to the other...

No problem...thanks for bringing out the conversation. If you have a moment please post back if there are further findings or developments in the data type choice.

No problem...if you have a moment please post back when you arrive at the root cause and/or a solution.

I only presented the INSERT INTO...EXEC() AT technique because you...