Please give me some advices about my DTS+MSMQ solution!!

Please give me some advices about my DTS+MSMQ solution!!

Post by Andy Ch » Thu, 10 Jul 2003 18:10:30



Hi, dear all,

The problem I faced is to replicate data between two SQL
Server 2000 via

internet. And the data will be managed before replicate.
To improve reliability,

my solution is:

SQL Server DTS---MSMQ--------------------MSMQ---SQL
Server DTS

Since I have litter knowledge about SQL Server and MSMQ,
I worry about whether  

the solution is right and what trouble I will meet during
development and

deployment.

So PLEASE give me some advices.

Thank you for you help!!

-Andy

 
 
 

1. Please give me some advices about my DTS+MSMQ solution!!

Hi, dear all,

The problem I faced is to replicate data between two SQL
Server 2000 via internet. And the data will be managed
before replicate. To improve reliability, my solution is:

SQL Server DTS---MSMQ--------------------MSMQ---SQL
Server DTS

Since I have litter knowledge about SQL Server and MSMQ,
I worry about whether  the solution is right and what
trouble I will meet during development and deployment.

So PLEASE give me some advices.

Thank you for you help!!

-Andy

2. LOAD_FILE(file_name)

3. MSMQ and SQL7 - MSMQ Wont Start

4. Not a table/DBF file

5. MSMQ Task within a DTS package fail to execute due to Authentication

6. Converting Access SQL to SQL 2000

7. DTS and MSMQ

8. Duplicate Rows

9. DTS MSMQ VB/ASP

10. DTS Pakage(MSMQ Task) fails due to authentication

11. Give me a solution pls

12. SocketPermission exception?. can anyone give me solution

13. CDaoRecordset::AddNew is not giving me proper solution????