if the PROC2 is depends on the the successful execution of PROC1 then you need to use

SET XACT_ABORT

otherwise...

Koen Verbeeck (5/16/2014)

---

Am I the only one who thought the question was worded a bit strange?

Anyway, as stated...

Phil Parkin (5/14/2014)

---

twin.devil (5/14/2014)

---

What error you get this time? it should not be the same as the earlier one....

What error you get this time? it should not be the same as the earlier one. but if it...

mssqlsrv (5/14/2014)

---

I got the point that while insert we should drop and recreate the indexes.

But we are not rebuilding indexes on "table".

Here the schema bound views and its indexes are...

Sorry, i just noticed i have replaced your code with mine. This function is also valid, but for single Character only.

Following is the complete code

using System;

using System.Data;

using Microsoft.SqlServer.Dts.Pipeline.Wrapper;

using Microsoft.SqlServer.Dts.Runtime.Wrapper;

using...

As far as i remember, you actual issue was on ID column not the Name Column

update your code like this:

{if Char.IsNumber(Row.ID)

{

Row.isvalid= true;

}

...

I just written this as per my understanding

CREATE TABLE #events

(

eventID int,

eventname char(30),

startdate date,

enddate date

)

INSERT INTO #events VALUES (1,'testevent 1','2014-05-02','2014-05-30');

INSERT INTO #events VALUES...

I still cannot understand the context of your situation but the...

to err is human 🙂

Nice question thanks for sharing.

Share your scenario why you actually need this working, and at which point you need this column? need more understanding.

When you say column header you mean its name, like to make ColumnName_20140512 something like that ?

Nice question ... brought back some nice old memories ... 🙂

Thanks for sharing

is there some kind of restriction ?

if its a yes then you can place a Script Task, create a Boolean flag...