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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-29 : 09:33:57
|
| Rob writes "I have used SQL Server 2000 for years and to date have never had a problem in creating a DTS package (using the Import Export Wizard) that will import data froma production database to my local development database - dropping and recreating the tables and importing all the up-to-date data from the production db.If this same system is possible in SQL Server 2005, can you please give me a step by step as to how it is done - just so I know it's not me doing something stupid in the SSIS wizard.The option to Drop and Recreate the tables is greyed out.The operation fails if I try any other method (as would be expected).I have tried deleting the rows and allowing identity inserts, but it fails because there are foreign key constraints on the tables in question so the task cannot complete a truncation of the current data.This is madness.I cannot find a solution to this online - if you know of a solution, please let me know where I can find it!I am running SQL2K5 SP1 client tools on a WinXP Pro SP2 box - fully patched up to date.I have searched these forums and have not found a similar post.Many thanks in advance if you can provide the answer!" |
|
|
|
|
|
SSIS Drop and recreate tables greyed out