Business rule column in not a consistent one. I have given two columns as example. But it may contain 2, 3 or more column names under business_rule.

Yes, I tried with...

Thanks for the reply.
Yes, I understand that table needs to be normalized. But is there any way that I can use the filtered column name in select query with...

Hi John,

I faced such issue in my work.

I used two row_number() function

1st row_number() with partition by docno and date1

2nd row_number() with partition by docno.

But i could not order them in...

I need to implement under data flow task. as i need to dynamically compare the values.

I am getting file like Text-23.05.13 [dd.mm.yy]

out put should be : 2013 and 23.05

For that i used regular expr: (?<Issue>\d{2}\.\d{2}).(?<Year>\d{2})

The 20 value is not coming before 13. i need this.

Please...

Hi

It can be done by following way

Now.Date.ToString("yyyy") + Now.Date.ToString("MM") + Now.Date.ToString("dd") + "_" + Now.ToString("HH") + Now.ToString("mm") + Now.ToString("ss")

thanks

Rohit

Thanks For your suggestion.

I am using SSIS 2005. and it is not possible to export records to Excel 2007.

[Since it is supporting only .xls files.]