Viewing 15 posts - 1 through 15 (of 2,611 total)
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...
March 11, 2009 at 7:07 am
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...
March 6, 2009 at 10:58 am
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.
March 6, 2009 at 9:17 am
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...
March 6, 2009 at 8:30 am
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...
March 6, 2009 at 6:11 am
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...
March 6, 2009 at 5:32 am
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.
March 5, 2009 at 10:27 am
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...
March 5, 2009 at 6:10 am
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...
March 3, 2009 at 7:43 am
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...
March 3, 2009 at 7:36 am
Beyond telling you to buy a book or take a class, your question is way too broad for a forum post.
February 27, 2009 at 6:32 am
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...
February 27, 2009 at 6:25 am
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...
February 26, 2009 at 8:05 am
You can query with a 3-part name:
Also, you can create a synonym in your database that refers to an object in another database.
February 24, 2009 at 11:57 am
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...
February 23, 2009 at 8:49 am