That happens to me all the time....

You don't need 'between' when you've got C#! Nor in SQL Server, to be honest - it's just a short cut that can be achieved through other means.

In pseudo-code:

(time >=...

Why not just use the Row Count transformation?

Use an Execute SQL task. The results of the task (eg a single value) can be mapped directly to a variable (I don't have SSIS running at the moment, so...

The way I would do this is to physically store something within a database which the package will use when it runs. Your first step when the package runs is...

What component/expression is causing the error and what is the exact error?

Please post the exact error message.

da-zero (8/20/2010)

---

Yeah, you're right - that's me done for the day now...

Maybe that should be

U wordt enkel gesponsord door McDonalds

da-zero (8/19/2010)

---

Sorry if this sounds rude:

if you want the complete solution, hire a consultant.

Phil and I have given you enough hints so that you...

Now who would have thought of doing that? 🙂 In Dutch too.

Maybe you should read about configuration files - they might give you the flexibility that you need.

Of course SSIS will have problems if it's looking where it's been told and there's nothing there.

The simplest option (in terms of coding, that is) is that you change your...

veera.1255 (8/18/2010)

---

Report Designer: Supports the report creation phase of the report lifecycle. It is an add-on tool for any edition of Visual Studio .NET 2003, suitable for both programmers and...

Something like that ... FALSE maybe 🙂