A full process reguilds the entire cube structure, so no residual data could have remained.

It could be a coincidence that the duplication happens to be 500 records. It is...

If you have multiple steps in a job, each step will establish a new connection. They may or may not be issued the same spid.

I find that hard to believe. This would seem to be a bit of a widespread problem for them and it would impact more than just SQL Server.

From in the SSIS package?

There is a system variable in SSIS called MachineName that will be the server the SSIS package is executing on.

You should contact your SAN vendor. This is something they should have taken care of for you.

No.

To run an SSIS package, you have to be executing the package on an SSIS Server.

Here is the MS support information link http://support.microsoft.com/kb/897615

There are lots of versions of VMWare. The particular version being used will determine if it will work.

Even the versions that do work are only partially supported by Microsoft....

SUBSTRING("0" + (DT_WSTR,6)TRDAT6,1,2)

Your expression is fairly simple:

"OFFICEUTILALLOC" + RIGHT("00"+(DT_WSTR,2) @[User::Month],2) + RIGHT("00"+(DT_WSTR,2) @[User::Year],2)

As far as the format of a variable - variables don't have a format, they have a data type. ...

Again my question would be which requires more protection? The operating system of the server that houses SQL or the corporate data that is housed on it?

From a...

If the packages are being run by the Job Agent, it is easy enough to check if the other job is currently running and wait (see sp_help_job).

If they...

You will need something like this:

[font="Courier New"]CREATE TABLE dbo.EmailHistory

(EmailHistoryID INT NOT NULL IDENTITY(1,1)

, EmailTo VARCHAR(250) NOT NULL)

GO

CREATE PROCEDURE dbo.SendMyMail

@EmailTo VARCHAR(250)

AS

--Send mail here

PRINT 'Mail Sent'

RETURN(0)

GO

CREATE TRIGGER trgEmailHistory_Insert

ON dbo.EmailHistory

AFTER INSERT

AS

BEGIN

DECLARE @EmailTo VARCHAR(255)

DECLARE...

Report Manager runs over http, so secure the box it is running on similar to the way you would secure any other web server.

It is fairly easy to check of existance. The following would be a cumulative script:

[font="Courier New"]-- January 2008 --

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usertable]')...