Posted by mark on 11/27/06 14:48

I need to update two fields in a few hundred rows in a table. I'll be
provided with a spreadsheet giving me the key field and the two new
values for each row. In the past I've done this simply by adding extra
columns in Excel to construct a T-SQL UPDATE command for each row, then
pasting into Query Analyzer to run the whole lot.

I've come across the Data Driven Query task in DTS but wonder if I need
to use it for such simple updates. Would the DTS route give me any
advantages or make it easier to repeat the task in future?

Thanks

Mark

• Next in forum: How to export SQL Database properties
• Prev in forum: Need Help to form the MDX-Statement
• Thread view: DTS Data Driven Query vs. Query Analyzer

[Reply to this message]