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 |
|
neverborn
Starting Member
1 Post |
 Posted - 2010-06-18 : 13:16:54
|
| I'm trying to migrate data from a production server to my own server every day at about 6am. Both are SQL 2005. I have tried the SSIS Import and Export wizard and it fails every time.This is for 1254 tables. In the Import and Export wizard, I select my tables (optimize for many tables is checked) and click edit mappings. I then click "Delete rows in existing destination tables" and "Enable identity insert."Once the package is created, I right click it and select "Execute Package." The package fails every time. I can't see anyway to copy the execute results, but here is some examples: "Task CompensatingSQL failed" "Task Execute Inner Package Failed"I'm on a seriously short deadline and very confused why this simple task is not working as I've used it on other databases with no problems. Appreciate the help. FYI - I'm a SSIS noob, I am relatively familiar with sql 2000 DTS though. |
|
|
|
|
|
migrating data from one db to another