The error is pretty clear - you do not have enough space available in the file group for the operation you are trying to run.

This could be that you are...

You are using a data source with integrated security selected. The scheduler does not like that because it does not have valid NT credentials.

You can select the option to...

In your processing procedure for the queue, call sp_db_sendmail.

Of course, this just puts a message into the dbmail queue, so another service broker layer is probably overkill.

Assuming you cannot just have foreign keys on your destination table, using 10 lookups will be fine.

I have had packages with more than 30.

Remember that in full cache mode the...

I am less concerned about using sp_send_dbmail in a trigger in many cases. If you do not have a query attaching or including results, the execution of this procedure...

Yes.

Use a for loop container and put an execute SQL task in it. Have the Execute SQL task return something to a variable if it is successful. Set...

There is a system variable (click show all variables) called something like IsInteractiveMode that will be true when the package is running in the BIDS IDE.

Let it do that.

It is just mapping the data type to a string because it does not know how to map it to anything better. This happens with SSAS...

It sounds like the correct approach.

Building a custom component is not that difficult. You will need to do some .Net development, but for what you are doing, it should...

Using partitioned taboles and multiple file groups is all about allowing multiple operations in parallel without a hardware conflict.

For example, if you have one user querying data for the current...

Beyond telling you to buy a book or take a class, your question is way too broad for a forum post.

The slowly changing dimension wizard component is ok for about 10,000 rows in a dimension. After that, the performance is so poor that you will probably have issues with...

For an application connecting to it for the database engine, you will typically not see any differences.

If you are using integration services, you may have some additional deployment issues and...

You can query with a 3-part name:

Database.ObjectOwner.Object

Also, you can create a synonym in your database that refers to an object in another database.

Seconds past midnight is pretty common and relatively easily handled:

DATEADD(Second,55228,'1/1/1900') --assuming 1/1/1900 as a base date

I have never seen the other date format used, but I suppose it...