p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning T-SQL with Microsoft SQL Server 2005 and 2008 ISBN: 978-0-470-25703-6 (http://p2p.wrox.com/forumdisplay.php?f=433)
-   -   Checksum calculation (http://p2p.wrox.com/showthread.php?t=88077)

amithfriends July 23rd, 2012 03:31 AM

Checksum calculation
 
Plz some one help me in doing this....

We get two types of files .dat and .chk files

.Chk file contains the checksum value of the .dat file


Our task is

1) Create a SSIS package using Stored procedures

Have to calculate the checksum value after we get the data and compare with the ckecksum value we got from them

Clean data Goes to one File and the other data goes to Error File

All the cleaned data should go in to the table with insert and update commands


if we get the same number we have to update the table
if we get the different number we have to insert in the table


All times are GMT -4. The time now is 05:42 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.