Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deepatarak
Starting Member
3 Posts |
 Posted - 2005-11-28 : 22:51:27
|
| In my application, on a menu click i want to copy data from certain tables in a databse on a server location to another databse with identical schema on another server. When i create the DTS package and run it from enterprise manager i encounter no problem.However when i execute it from my application,It takes the tables according to alphabetical order; it gets populated child table rows before updating master table. It gives foreign key constraint error while executing package. So our DB backup fails.An option i thought of to get of the problem was If I use separate DTS packages for each table and I execute DTS according to our DB relationship order it works but takes much more time.Any ideas would be welcome |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-11-29 : 17:07:04
|
| Why don't you use the workflows to define what order the tables are populated in??Strange that it works via EM but not via your app, though...HTH,Tim |
 |
|
|
deepatarak
Starting Member
3 Posts |
Posted - 2005-12-07 : 23:15:40
|
| Thanks it now works both from code & EM after defining workflows |
|
|
|
|
|
|
DTS package execution from code