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...

quasar_phoenicis (6/2/2011)

---

Koen Verbeeck (5/31/2011)

---

quasar_phoenicis (5/31/2011)

---

Hi,

I have a parent package with 2 execute packages tasks that are connected through a "success"contraint. Execute SSIS package 2 should not run until execute ssis...

I see your point.

Another option is to use an Execute SQL task to log start and end dates to a job status table - so you can track when the...

Interesting.

My first thought is to move the scheduling logic to a new script task at the beginning of the package, which executes the subsequent tasks if the conditions are...