Never seen this before. Why did you attach and deatch ? Same server ?
Have you tried scripting to VB , looking at the output and resaving through
the VB interface?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"edt" <anonymous (AT) discussions (DOT) microsoft.com> wrote

detached and attached. We have tried recreating the DTS package by opening
it and saving it as a new name and then creating the job to execute the
package using 'Schedule . . .'. Has anyone seen this? It seems pretty
obvious that it has to do with the detach and attach.

The database in question is 160+GB in size and has basically outgrown the server that it is on. The server does not have enough space to run a full database backup. It is expected to grow to approximately 350GB before the application support team can begin any kind of purge on the database. Another reason for moving the database is that the server that it resided on will go into a reboot after one of the most recent Microsoft security patches was applied. But, that has nothing to do with this problem. We had 2 plans for moving the database (because of the reboot problem) - one was to copy a complete backup file to the new location as well as transaction logs. Once the current db backup and tlog backups were copied successfully, a restore at the new location was done, leaving the database inoperable but able to restore addt'l tlogs. Once the last tlog that was copied to the new location was restored, one more tlog backup was taken on the current location and then the database detached. I don't know why detach was chosen versus putting the database in DBO use only. Anyway, when the final tlog was restored at the new location, the re-attach was done on the original home so that the application support team could run parallel for a week. Ever since the re-attach was done, the DTS package has failed with the message about 'no steps . . .' on the originating server.