DTS Data Integrity

#1

if a dts package is executed over the internet, how to
ensure data integrity i.e. how do we know that the data
was not corrupted during package execution. Is there a way
to find this out??

I am uploading data from client to server and if all the
data was transferred successfully, i delete them from the
client.
This is new to me, any thoughts will be helpful. What is
has value used for??

Thanks
Rashmi

#2

Thanks for your reply. How to use SSL, i am executing the
DTS using VB.net. I use the loadfromsqlserver function and
use the execute method to execute the package. where do i
mention it is an SSL.

Also what is Hashing used for?? any ideas

Thanks

Quote:

-----Original Message-----
In article <0b9d01c36825$7f2c3c70$a001280a (AT) phx (DOT) gbl>,
Rashmi
rashmi_nailady (AT) instron (DOT) com> writes
if a dts package is executed over the internet, how to
ensure data integrity i.e. how do we know that the data
was not corrupted during package execution. Is there a
way
to find this out??

I am uploading data from client to server and if all the
data was transferred successfully, i delete them from the
client.
This is new to me, any thoughts will be helpful. What is
has value used for??

Thanks
Rashmi

To prevent the data being tampered /sniffed you would
need to use a VPN
or SSL or even SSL over a VPN.

To ensure the transfer works before the delete you would
obviously use
workflow. This works for me.

If you are particularly paranoid you could run an Execute
SQL Task to do
a SELECT COUNT(*) on the source before the transfer, and
then run a
SELECT COUNT(*) on the destination post transfer, and you
can also see
the number of rows transferred by the DataPump through
the object model
properties, RowsCompleted - RowsInError. If the three
figures differ you
may have a problem. You may need to filter the SELECT
COUNT(*) and
transfer source statements to ensure you get a consistent
snapshot of
data if data is being inserted or updated during this
period.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

.

#3

In article <03a701c3682b$72e1d0f0$a501280a (AT) phx (DOT) gbl>, Rashmi
<rashmi_nailady (AT) instron (DOT) com> writes

Quote:

Thanks for your reply. How to use SSL, i am executing the
DTS using VB.net. I use the loadfromsqlserver function and
use the execute method to execute the package. where do i
mention it is an SSL.

HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft
Management Console
http://support.microsoft.com/?kbid=316898

HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?kbid=276553

Support WebCast: Microsoft SQL Server 2000: How to Configure SSL
Encryption
http://support.microsoft.com/?kbid=324777

You could also look at using IPSec, although this encrypts all traffic,
not just SQL traffic.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Data Integrity

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Data Integrity - 08-21-2003 , 03:47 PM

Re: DTS Data Integrity - 08-21-2003 , 04:30 PM

Re: DTS Data Integrity - 08-26-2003 , 01:24 PM