#1 DTS packages are stored in sysdtspackages. SSIS packages are stored in sysdtspackages90.

#2 Look at the properties of the Execute Package Task in the parent package. It's possible...

You can find the version guid values by querying msdb.dbo.sysdtspackages. Once you know that, you can see which version is used in the DTSRUN command and you can specify...

If he had saved the packages with one of the protection levels I mentioned, you'd be prompted for the password when you open the package. To be sure, maybe...

Sorry, I'm not clear what your question is. Do you want to be able to restart a job at a particular step or do you want to restart a...

Most lilkely, the team member saved the packages with the default protection level EncryptAllWithPassword so nobody can open the packages exept that user. Have him or her save the...

There are some SQL Server Agent fixed database roles in msdb that may help you if you assign some users to them. See the details in BOL for SQLAgentUserRole,...

I had a similar problem with allowing a job to be started from an asp page. You may be able to adapt this to your situation.

1. Create a SQL...

Try adding Psychemedics\OnlineServices as a user in the ClientServices database with no permissions. That should allow the stored procedure to work.

I've done that, but I've come to prefer this tool: http://www.sqldts.com/242.aspx. It's way easier to use and is dead dependable...and it's free.

You can create a global variable in the package to hold the file name/path and use it to set the text file connection. Here's a link to some sample...

If you want to retrieve the identity value for the row just inserted in the same stored procedure, I don't know why SCOPE_IDENTITY wouldn't work. Can you elaborate on...

I've used it and it does just what you've described - allows the user to execute user stored procedures and functions in the database. The drawback is you can't...

By default, those schemas are owned by themselves, so db_datareader is owned by the db_datareader role. I'd just use the schema properties in SSMS to change the owner, then...

Actually, if a step is removed, none of the other steps need to be modified unless the step that's removed is the last one. Same with adding a new...

Our backup jobs have a step for each database. That makes it easy to continue if a step fails by setting the on failure action to 'go to the...