I'd like to see that. Please provide details of how the FST can create Excel...

Randheer (3/13/2011)

---

You should be prepared before going to the interview and I believe there is no harm if you know what you are ignoring while doing your regular work.

so get...

I'm interested to know how you avoided getting a meta-data error as a result of the expected columns being missing on the dodgy row?

It would be useful to know why though, as it's an unusual request. Instead you have avoided the question and simply restated your original post.

select Coalesce(NullIf(CurVal5,0), NullIf(CurVal4,0), NullIf(CurVal3,0), NullIf(CurVal2,0), NullIf(CurVal1,0))

should...

I've tried, but I don't know what that means. Is there a date in there from which to determine 'last'? Is...

alexanderbebe (6/9/2011)

---

it is 2003 excel file. yes i gave without quotes.

Later, i tried by renaming the excel file from xls to xlsx but i am getting the error as "Could...

Please include a screen shot of the control flow - perhaps just after it has failed to demonstrate where it failed.

Also include the text of the error.

Have you considered using SSIS to do this? It could handle the commits as you wish.

Thanks for the blog link - I learnt something useful today.

GilaMonster (6/8/2011)

---

The clustered index does not force physical storage order of data.

All indexes, if they can be used, reduce the IO cost for queries. That's the whole point of an...

hl6a (6/7/2011)

---

Hello there,

Is it possible to use precedence contraint to bypass a task? For example, the control flow starts with task A, checks an expression, if true, run B then...

Another problem is where Tax_Period is a stored as a string (which it appears to be), and not a numeric, as exemplified below:

DECLARE @Tx1 VARCHAR(5), @tx2 VARCHAR(5)

SET @tx1 = '21'

SET...

Note also that custom formatting in Excel has no effect on the data which is stored or extracted - it is a display format effective only in the Excel application.

Is that Craig Chris or Phil Chris? 🙂

We need to know what you will be doing with the dates before we suggest the best solution.