I have the DDT up and running and have the package setup just like I want (i.e. PK and FK structure correct, all sprocs set to be created, etc). When I run the package, it runs without error but the last step deletes the database it created at the beginning. I tried creating the database before running the package. This caused an error at the top of the package (when it tried to delete the database) but still deleted it at the end.

I have used the DDT without problem in the past and have no idea what I'm doing wrong.

Thanks

Clay