[dba-VB] C# - Direct data manipulation

jwcolby jwcolby at colbyconsulting.com
Wed Dec 2 12:34:54 CST 2009


I receive lists of names in CSV or fixed width files.  I import those into SQL Server, creating a 
PKID in the process.  I then have to export the PKID plus the name / address monthly for address 
validation.  Once validated, I have to import the data back in.  This is the monthly process. 
Approximately 1% of all the people on any given list move each month.  So I have to go back in to 
the original list and update 1% of the addresses, or simply swap out the new list (table) for the 
old.  There is never any manual processing of individual names inside of these lists, IOW people 
never look at them, modify them, add new ones, delete address or anything like that.  The list is 
"stable" in that regard.

These lists become the source for orders of names.  Orders are a whole 'nother process, but also use 
SPs to do their thing.

John W. Colby

Shamil Salakhetdinov wrote:
> Hi John --
> Thank you for your reply.
> Do you use your different databases for data input, or you also have to
> update those different databases' tables?
> --
> Shamil

More information about the dba-VB mailing list