Also, give the group names an alias name so that you can refer to the alias in the script rather than the full domain workgroup name.

In addition to backing up msdb, however, which backs up all of them, I strongly recommend you back each package up as a structured storage file to a folder that...

We create a temp table which is then filled in with the resulting values which are then joined through a stored proc to a fixed statement.

In this case, we would...

I didn't start doing it the way I outlined above, since nothing in any book I read indicated to do it that way.  But when I would do test restores,...

I agree that truncating the log prior to backup is a bad idea.  We use a scheduled job to b/u the db with the following steps:

1.  Integrity check.

2.  Reindex.

3.  B/u...

I would generally recommend using MS Excel (2000 or better; earlier versions can't do OLAP reports).  Most people who use the cubes are very familiar with Excel, so they don't...

Do you have to use the FTP process to move the files around.  If it's your own network, can't use move the files using the File Scripting Object?

I have it installed on my SQL boxes, and while there are problems from time to time which cause me to have to restart the server, the only thing that...

From above:

I believe (although I've not checked) that if you look at the query execution plans for JOIN vs. WHERE it actually amounts to the same thing. This would make...

This is actually helpful.  The next thing I'd like you to do is to right click on each step to run it individually.  Once you get to the step that...

What does it say?  Telling me the information is no good doesn't help.  You may be right, but let's see it first.

The suggested method works well when you can determine the name.  When you can't, use the following method:

Dim fso, folder, file, filecollection

Set fso=CreateObject("Scripting.FileSystemObject")

Set folder=fso.GetFolder("<<Path>>")

Set filecollection=folder.Files

For each file in filecollection

 DTSGlobalVariables("ImportFileName").Value=file.Name

 Exit For

Next

DTSGlobalVariables("ImportFilePathName").Value="<<Path>>\"...

Why must you use an indexed view?  We use stored procedures and SQL statements to return recordsets to unbound Crystal Reports.  As long as the SQL queries are well written,...

Do you have the package set to output to an error file?  If so, what does it say?

Depending on the level of control you need, you may be able to just use the icons.  But if you need a finer control, use an Active X Script in...