You could just copy the log files to another location and delete them as they age past one year. I haven't done it, but I'll bet there's a way...

When I try the steps you describe, I can't see any legacy DTS packages when I click the elipse. I only see SSIS packages, so I'm not sure how...

Execute permission doesn't apply to views. Do you mean you tried granting select permission on the view?

When you save a package you choose whether to save it to SQL Server or to the file system. If the package is saved to SQL Server, it's stored...

That is not a query. It's an encrypted DTSRUN command for a DTS package. Here's how to see unencrypt it:

1. copy the command to a cmd prompt, append...

Kerry,

Interesting question and I had to try it to see what would happen. If you schedule the job to run monthly on the second, third, fourth, and last Sunday,...

You can get a series of sp_grantlogin statements for the current Windows logins by running this:

use master

select 'sp_grantlogin ' + name

from syslogins

where isntname = 1

Then, as Jack suggested, edit the...

Do you mean you migrated a DTS package to SSIS? You can see SSIS package in SSMS, but you can't edit them there. You must use Business Intelligence...

Amit Gupta (11/19/2008)

---

i solve this problem, but i am confused that if i have 3 diff backup(3 days file) and restore 3rd day restore 1st then 2nd day, then 1st...

Within a package, step execution order is controlled by workflow precedence constraints. They sequentially link the tasks in the package. See "DTS Package Workflow" in BooksOnLine.

I can only...

You can find DTS packages in Management Studio Object Exporer under Management -> Legacy -> Data Transformation Services. You have to have the DTS Designer components installed on the...

Look at the default trace which is enabled by default in SQL 2005. It's a great way to find out this kind of thing.

Here's a recent article about how...

The user has to be the owner of the jobs to edit them. Only members of sysadmin can edit jobs they don't own. It won't even work to...

I'm not really clear about what you're asking. Do you want to know workflow between steps within a package or the order that multiple packages are executed or ?

You could write a query that joins msdb.dbo.sysjobs and msdb.dbo.sysjobschedules or run sp_help_job and sp_help_jobschedule.