Bob,

If this happens again , take Steve's advice and restore the database backup to a new database and export the data that was deleted...

Unless the backup file is encrypted, you can open it with Notepad.  It's unstructured and a lot of stuff is unreadable, but there's some plain text in there.  The contents...

Hi,

You can't put a database in recovery status before restoring a backup.  You should restore the full backup using WITH NORECOVERY so uncommitted transactions are not rolled back.  Then restore all...

I believe there's an article about how to do this at http://www.sqldts.com, but their site is inaccessible right now so I can't verify that.

I have a similar requirement in...

I haven't had any corrupted packages, but I've read about packages becoming unusable when transferred to another instance having to be recreated.

There is a Bulk Insert task in DTS and...

I believe it's sysjobhistory and sysjobstepslogs in msdb.

Greg

Elma,

What you posted is the information that's displayed in the job history.  You have to have enabled logging in the package to see the package log. 

To enable logging, open...

SQL Server has used only Windows logins for DTS package ownership for as long as I've used DTS, since SQL 7.0.  I've never been curious enough to find out why,...

Elma,

Do any of the steps in the package log have a Run Status of 0?  If so, that step never finished.  I see this occasionally with a package that uses ODBC...

The common recommendation is to NOT enable autoclose.  As Arun said, if it's disabled, you won't get the messages and you won't experience the performance hit of constantly changing the...

He shouldn't have to connect to Integration Services if the package is still a SQL 2000 DTS package.  But maybe I shouldn't have assumed that. 

How about it SBICKFORD, is...

If you had some kind of DDL auditing running - DDL triggers, Profiler, etc., or you have a transaction log reader tool like Lumiget Log Explorer, you could find out...

Did you save the package as a file then import it in Management Studio?  That worked for me. 

Greg

Yeah, I know the recommendation is to convert packages to SSIS, but my point was that you can maintain and run DTS 2000 packages in SQL Server 2005 indefinitely.  I...

Restoring system databases is not the only way to migrate users, logins, and jobs.  As Joe stated, you can script all of those in SQL 2000 and recreated them in...