Geeks With Blogs
Rohit Gupta Engaging talk on Microsoft Technologies ....My Resume
January 2007 Entries
Data Driven Query Task in DTS for updating data from Excel into SQL Server table
This is a very common issue we face. There is a Excel sheet with data that needs to be imported into SQL Server table. The SQL Server table has unique key/primary key constraints on a key column (e.g. InspectorID). However the Excel spreadsheet can contain duplicates since this either being generated manually or coming from a different data source (typically a data warehouse). To be able to create a DTS script that uploads data from the Excel spreadsheet into Inspector table : I divided the Inspector ......

Posted On Sunday, January 21, 2007 5:40 PM

Copyright © Rohit Gupta | Powered by: