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 |
|
tk78
Starting Member
1 Post |
 Posted - 2009-01-19 : 01:44:13
|
| Here's my problem. On a production db, there is a table that has one column that has been overwritten with bad data and needs to be restored from a few days previous. The vendor issued a sql statement to be run that had a syntax error. The issue wasn't discovered until it was too late to go back from a restore. I've tried looking at a DTS copy column, but it looks like this is more for inserting data, not updating data within a table.Any help is appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-19 : 02:15:06
|
| just use Execute SQL task and use UPDATE table SET column=.. query to update the column with correct value |
 |
|
|
|
|
|
Column Fix