Had to edit this as I got my postings crossed.

You can use the task referred to above for processing the dimensions, but you will have to do so individually.  I...

It also sounds to me as if a stored procedure is missing because of the second part of your message.

Re the error message: "Cannot add rows to sysdepends for the...

Yes, I understand.

As I indicated already, you need to follow the procedures listed by the previous answer to use a ? and attach that property to the global variable.

I do...

You only need to use the dynamic properties if you are using the global variable to change the property of one or more object items.  For example, if a global...

You can use the dynamic properties task to make the output file name anything you want.  I use it to take in files when the names constantly change (and sometimes...

While it's true you can do this this way, for your purposes the data driven task is a better choice.

The main purpose for creating a recordset global variable with the...

Take the time to learn to do this through QA.

Also, you don't say if the temp table code is for an application, but if so create the temp tables in...

This could easily be scheduled to work automatically. 

You can use the staging table, which is fine, or you could delete the portion of the permanent table which will be...

I would use a combination.  Run the execute task to run your pre-queries.  Use the data driven task to run the query that outputs to the file. 

The data driven...

Excellent point.  I work with one domain over which I have complete control.  Therefore creating a role is tantamount to creating a group with an extra layer.

Based on what you...

You're welcome.

While I would normally defer to one much wiser in the ways of SQL Server than me (really, I mean that) I have spent...

I recommend against using roles if you have control over the domain.  Windows groups are much more efficient.  Roles are most useful when you don't control the domain in which...

I would do something similar to the following:

Function Main()

Dim fso, file

Dim pkg, stpNext

Set pkg=DTSGlobalVariables.Parent

Set stpNext=pkg.Steps("<<Name of next DTS Step>>")

Set fso=CreateObject("Scripting.FileSystemObject")

Set file=fso.GetFile("<<FileName>>")

If file.DateModified (Your logic here) then

--If you want it to stop

 stpNext.DisableStep=True

Else

--If...

Rather than fail the package, I would use the file scripting object to get the file you want and then examine it's last modified property.  If it's within the range...