Connection Managers are not connections, they serve connections. So, by default they will connect to a data source more than once. You may have an ODBC source that...

A bit field should be evaluated as:

False = Zero

True = Not Zero

Neither true or false = NULL

There is no way in the installer to exclude the agent. Is it not appearing in Management Studio?

Download an eval version of SQL 2008. You can actually do this in management studio.

Full Sun http://www.fullsun.net/ has a freeware tool, Quest does as well.

You get what you pay for here, spend some time looking and evaluating, but I think you will either end...

- Create a job

- Add a step

- Choose the step type for executing an SSIS package

- Select the package you want to run

The UI is fairly intuitive, you may want...

Perhaps I missed something in your post, but are you asking why a lookup fails if there is no data in the lookup table?

By default, if a value is not...

I get it - you are using packages stored in the MSDB database, not the file system.

You should be able to do this with a loop container and an expression...

Triggers may work for this, but they could cause you a lot of trouble. Since they are part of the transaction that fires them, they can hurt performance and...

Look up DDL triggers in books online.

Thus far, it appears so.

I agree that it is pretty crazy to start a project on one platform making the assumption that you will have to switch to another platform unless you are taking...

Before you go building a report distribution system, if you are using the enterprise edition of SQL you should look up data-drive subscriptions.

You are not understanding how filters work in a cube.

Any time you filter data in a cube, you filter the entire fact set.

All filter conditions will result in an AND...

It is really going to depend on what your triggers are doing.

If, for example, you have a trigger that takes 30 seconds to run, if it is on one of...