Make the first step of the each job (except the first one) run a query of msdb.dbo.sysjobhistory looking for job_id = the id of the job that is the precedent,...

You're welcome. It really makes a difference when we can see the actual error message.

Greg

You may have discovered by now that the Migration Wizard is for converting DTS packages to SSIS packages, not for moving them to a SQL 2005 instance as legacy DTS...

Me too. I think I saw a comment from Steve recently where he said he would look at bringing it back but it was incompatible with the current forum...

There isn't a forum specific search, but you can use the search box in the upper right corner of the page and it will list forum posts that relate to...

We saved DTS packages as files using DTSBackup2000 from http://www.sqldts.com/. In SSMS in the SQL 2005 instance, we imported the package files and saved them to SQL Server, then...

Whether it's possible depends on several things. How much time elapsed since the data was deleted? Do you have backups of the database? Do you know what...

I suspect this is the classic "SQL Server Agent security" problem. I've found this KnowledgeBase article helpful: http://support.microsoft.com/?kbid=918760

Greg

It looks like the package is starting and the error is generated by DTSStep_DTSDataPumpTask_5. Check the connection used by the Transform Data task and make sure it's set to...

Do you have "fail package on first error" property set in the subpackage? If not, it would complete successfully and the Execute Package task in the parent package would...

The specific permissions the login needs in msdb are EXECUTE on sp_enum_dtspackages, sp_get_dtspackage, and sp_get_dtsversion.

Would you post the exact error message that the user gets? Have you...

I've used DTSRUNDEC and it does work, but the method I described was easier to use so I've stuck with it. I'm curious about why it didn't work for...

I may not understand your question. Do you want to know what SSMS does behind the scenes when you run something in a query window? If so, then...

That will only work if the package name was used in the step description. What you need to do is

decrpyt the DTSRUN command. Do this:

copy the command to...

Do you get an error when the job fails? If so, please post the error message here.

Thanks

Greg