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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-04-13 : 10:50:23
|
| Hi I've 2 servers with the same table on both, to get the same table format I used the Generate SQL script and then run this in query analyzer to create the 2nd table when I test my DTS data transform it works fine as it goes to a temp .txt file but when I run the package it fails and I can't figure out why ? any ideas on how i go about fixing this or looking for the problem? |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-04-13 : 11:12:14
|
| FYI.. The Error i was getting was the "connection is busy", the server i was connecting to is a live stream of data so its updating all the time, hence i could not take the data from the database as it was locked for writing.. |
 |
|
|
|
|
|
Extract Faild