That option is not available in the job agent in SQL 2005. You have to call the SSIS package using the CMD step type and give the path to...

One of the field you are summing is adding up to more than 2.1 billion on one of the servers - this is a data problem.

Convert to a BIGINT first:

SUM(cp.size_in_bytes)...

Assuming you really only have 6 reactions, a crosstab will work:

[font="Courier New"]CREATE TABLE #Reaction (ReactionID INT, Description VARCHAR(20))

INSERT #Reaction VALUES (1,'Amnesia')

INSERT #Reaction VALUES (2,'Wheezing')

INSERT #Reaction VALUES (3,'Rash')

INSERT #Reaction VALUES (4,'Fatigue')

INSERT...

Your client is a web browser and the WMI call would be coming from the web server in an intranet environment, so a VPN disconnect on a web session could...

What do you (or they) intend to use this field for?

Doing this kind of generation and ensuring there will be no holes can cause a lot of problems. First,...

Your processing query for your facts is timing out. By the name of the partition vFact, I assume it is probably from a view, but there are other factors...

It's been nice building a new system from scratch for the past year. I haven't had to look at anyone else's nasty code in a long time.

I don't understand the security issue - if the user can put the script in the queue, then running it from the web page directly seems like it would be...

No index is ideal with a GUID using NewID(). You should change it to a sequential GUID - this may significantly help your performance issues as a NewID() column...

Use a ForEach loop container to loop through all of the files in the directory and put the file system task in the loop.

What adds the record to the table? Why doesn't it just call the WMI script directly?

By putting these into a table, you are essentially creating a processing queue. ...

It is going to depend on a lot of factors.

Since you cannot tell when a record has been inserted or updated based on the record itself, you have to look...

You can do this with a script task and some VB.Net, but unless you are familiar with .Net development, the script task, and ftps, I would recommend purchasing a 3rd...

You cannot save the password in the package - it is a security measure taken in SSIS. Look up "package configurations" in books online. You can create a...

There are a number of MS SQL database comparison tools on the market that will compare your database schema's and generate change scripts. A great one is by our...