That sounds bad!!!

You should be able to do that with a simple UPDATE statement.

GilaMonster (1/14/2016)

---

Alvin Ramard (1/14/2016)

---

GilaMonster (1/14/2016)

---

He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he...

It depends if the rhino lets it go or not. 🙂

What the hell....

GilaMonster (1/14/2016)

---

He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he asks "What's a...

Seriously Gail? "Restore a backup you took before the update." 😛

Backup? What backup? :w00t:

I suspect the OP didn't make a backup first. I wouldn't be...

..... oops ....

I know it's not the easiest solution, but the best solution is to completely rethink, and redo, the packages. You might find that in some cases, you can get rid...

Fine! I'll go to Nashville by myself! 😛

Mayank Khatri (1/13/2016)

---

We are migrating our current SQL server 2005 to 2012. We have many SSIS packages in 2005 that are using ActiveX script task. Since this feature is depreciated...

SQLRNNR (1/14/2016)

---

I know a few people that are. Timing was bad for me. I am going to need to try a...

Manually recreating your source and destination to accommodate the changes should be no problem. Having the package do it automatically at runtime is basically not possible.

It's all .NET, so could just try a script task or transform in SSIS. 😀

Anybody coming to Nashville's SQL Saturday this weekend?

You could also use a Row Count in the Data Flow and compare that with the rows loaded, but that will only give you an accurate count if all the...