this would simply ignore the other characters in Vcode field. While the other characters should be inserted as new row in new table (mytable).

Thanks a TON!!!!

The query works very well.

the enddate for rowid = 3 comes form startdate-1 from row id = 4.....

and for last row id there is default value.

posting a sample output required.

Rowid deccode tarief Startdate Enddate

1 010127 4300 2005-01-01 2005-12-31

2 010127 4300 2006-01-01 2007-12-31

3 010128 4300 2008-01-01 2004-12-31

4 010229 4300 2005-01-01 2005-12-31

5 010230 4300 2006-01-01 2099-01-01

when...

Thanks for all the help!

But may be I did not get the partition part .

No, a startdate from one deccode cannot be used as the enddate for another.

The end date...

the data is partitioned on deccode, tarief and startdate

e1.startdate or e2.startdate can be used, but dont know why, there is NULL in some rows, while there exists data in all the rows of s.startdate.

I know NULL can...

The query does not give result as desired.

The enddate for rowid = 1 should be 2005-12-31 while it gives 2004-12-31.

The query seems to be substracting 1 from the same...

There are no gaps in rowid.

The enddate for row = 1 should come from rowid = 2,.... and for last rowid there is default value

this works for me!!

RTRIM(LTRIM(REPLACE(mycol,"\""," ")))

If there is any better way let me know!

yes, i can use Create Index with Drop existing and it is working fine.

But I still dont understand what is wrong with the former statement.

Finally I got this to work!!!

Just changed the configure error to ignore failure (its bad n risky !!)

But it worked and gave me the values I need.

But something I...

My expression looks like

(Enddate_new) == " " ? NULL(DT_DATE) : ((DT_DATE)(SUBSTRING(Enddate_new,7,4) + "-" + SUBSTRING(Enddate_new,4,2) + "-" + SUBSTRING(Enddate_new,1,2)))

I guess it says the same.

Let me know if I...

How do you write expression to put NUll (empty) value in date field when i/p has NULL value else cast it in YYYY-MM-DD format.

My i/p file is CSV file (the...

DT_Date

SSIS have taken the below syntax in derived column but when I execute the task it passes an error.

Error is :

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column"...