I just had this same issue when trying to build a pre production instance of RS 2000 sp1.

After setting everyting up and restoring the production database, keys etc etc etc...

Jacob,

Firstly thanks on a great article, I always like to learn new ways to skin a cat.

I thought it important to advise of this note I found in books online...

Rajesh,

This may be cecause of the account that the task is being run under. If this account doesn't have the correct permissions to call the stored proc or access to...

Brad,

you can use the sp_adduser, sp_grantdbaccess and sp_addrolemember system stored procs to create the accounts and set up their access.

David, If you enter the user name and password details at the front screen, click advanced, enter any global variables required and click generate you will see that it creates...

David, from the cmd line type dtsrunui. Once the app starts enter the relevant sql server amd package details and click advanced. This will then open a window that allows...