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 08:34 AM.

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