Do you still have the old package? If you do, open it in DTS Designer and save it with a new name. Then you can open the new...

I'm a little confused. Early in the thread it sounded like you want to remove the identity property and retain the data, but your last post sounds like you...

I don't think so. Nothing has ever broken the dozen or so times I've run sp_changedbowner.

Greg

When you ran the Package Migration Wizard, it should have asked you to select a package destination, either msdb database in a SQL 20005 instance or a .dtsx file in...

If your goal is to migrate a database from SQL 2000 to SQL 2005, I suggest using either the backup/restore or detach/attach method. I've never been a big fan...

Can you describe how you migrated the packages? Did you copy them from a SQL Server 2000 instance to a SQL 2005 instance? Do you expect them to...

We've used Lumigent Log Explorer for about 5 years and I've got no complaints. It's easy to install, the GUI is pretty good and it wil read either active...

Another note, since there was a recent thread from someone who was confused about the use of the Package Migration Wizard. It converts DTS packages to SSIS packages rather...

Hmmm, I'm not sure since sysforeignkeys stores each component column as a seperate row. I'll to some experimenting and post back.

Greg

I have this same situation. I have the step that checks for file existence go to the last step if the file isn't found. That step sends the...

I use this:

/* Generates script for recreating foreign key constraints. Run BEFORE running

DROP statements, that is, while the foreign key constraints still exist.

WARNING: this script does not pickup the...

Not that I know of. MS probably didn't think it would be useful to force SQL Server Agent to switch error logs since it archives and overwrites automatically.

Greg

I don't get how the number of lines of code can tell you anything about the complexity of a package. I would think understanding what the tasks are doing...

What about backing up to local files and FTPing them to the central location where the tape drive can be used.

Greg

I hear you! DTSBackup2000 at least lets you save all the packages to files without having to open each on in DTS Designer. Small consolation with that many...