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.

Aargh, Farrelled again! 😀

From what you say, it sounds like you want a completely flexible number of parameters (from your "..all dates in the last 2 months" comment).

Have you thought about setting up...

Use a conditional split to redirect the unwanted lines to an unused output as part of your data flow.

One easy way is to put your dataflow inside a Foreach (file) container - using the input file's name as the filespec. Then it will not execute if the file...

Gangadhara MS (6/3/2011)

---

Dear All,

I have a table with 5 column out of which one column datatyp is "Datetime"

ID,Country,Dateruled Isactive

Ex: 1,India,Rural,2008-05-15 18:30:00.000 ACTIVE

The datatype for the Dateruled column is of...

No problem - but you'll need a dataflow for each one.

You can't easily do this dynamically, if that's what you're thinking of.

Sriram.RM (6/2/2011)

---

found a work around..... thought might be helpful to others.

Add an empty result set at the top with the same structure as the select statement, this will return the...