DDT and Database Creation
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



DDT and Database CreationExpand / Collapse
Author
Message
Posted 10/13/2006 1:05:50 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 11/16/2006 1:23:18 PM
Posts: 40, Visits: 85
Hi Folks

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

Post #3567
Posted 10/13/2006 1:11:35 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 06/17/2008 9:28:35 AM
Posts: 2,649, Visits: 1,863
Most likely, you have a history record in your profile that is a deleted database record.  If you remove a database from the profile, then the DDT adds a delete history record to the history so that if it sees that database in the field, it knows to delete it.  But, if you then re-add the database, the DDT doesn't now to delete the delete history record, so when you run, it deletes your database immediately after it creates it.


www.bungie.net
Post #3569
Posted 10/13/2006 1:39:39 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 11/16/2006 1:23:18 PM
Posts: 40, Visits: 85
Cool...I deleted the history and off it went!

Thanks much.

Clay

Post #3577
Posted 10/13/2006 1:40:25 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 06/17/2008 9:28:35 AM
Posts: 2,649, Visits: 1,863
Not a problem


www.bungie.net
Post #3578
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 7:08pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 9 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.