Viewing 15 posts - 1,471 through 1,485 (of 2,612 total)
If you have just a dropdown box, wouldn't you only be able to choose a single field? You would be able to do this with a multi-value combobox, but...
May 28, 2008 at 1:30 pm
Yes, if you insert records in the order of the clustered index, you will not fragment the index during the data load. It sounds like you have it in...
May 28, 2008 at 8:27 am
Your error is further down. You need to log the package errors using SSIS logging, but you have a timeout happening in one of your connections. If you...
May 28, 2008 at 8:26 am
Please don't cross-post.
May 28, 2008 at 6:08 am
1 per survey is probably too many partitions. My suggestion would be to download the project REAL white papers from Microsoft. They did an actual implementation of a...
May 28, 2008 at 6:07 am
If you do not want to stop the services, you can also just do a backup and a restore.
May 28, 2008 at 6:03 am
You can get this message for a lot of reasons. You need to get the specific error messages from the error message list to determine what is wrong. ...
May 28, 2008 at 6:02 am
A tally table will give you the best performance, but I figured I would try this with a recursive CTE. Here is a way to do it:
[font="Courier New"] /*...
May 28, 2008 at 5:58 am
You are trying to connect to Server3 and your initial post indicates:
"I have created an 'sa' user on the server2 SQL Server 2000 instance that has admin privileges."
Then you go...
May 28, 2008 at 5:48 am
There are no triggers in Analysis Services. So, either you need some other plan, or I do not understand what you are trying to do.
As far as using SSIS...
May 28, 2008 at 5:38 am
Your permissions will have to be configured to allow access for the SQL Agent service account unless you have specified a proxy (which is unlikely).
What you have posted is not...
May 28, 2008 at 5:31 am
So you are either talking about 1 instance of SQL 2000 and 2 instances of SQL 2005 on a single server, or three virtual servers.
If you have three servers in...
May 28, 2008 at 5:27 am
I agree with Steve, if you run all of the machines on VMWare, you will take a performance hit, but you are only likely to have a single failure at...
May 27, 2008 at 2:37 pm
Turn on logging in the package and look for errors and other messages. It is likely a permissions issue due to the SQL Agent running under different credentials, but...
May 27, 2008 at 2:31 pm
Primarily Enterprise here - we use active / passive clustering on most of the servers.
May 27, 2008 at 2:29 pm
Viewing 15 posts - 1,471 through 1,485 (of 2,612 total)