![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Hi, I have a custom program which create an in memory DTS package. The program works fine and has been deployed in several computers. But on 1 computer I receive a general network error when I write the table in the destination (which is SQL Server) this error appear on some tables, but not all tables. What can I do to have a better diagnostic? thanks. Jerome. |
#3
| |||
| |||
|
|
Jerome, Perhaps you could use a software packet sniffer to look at what the TCP-IP protocol is doing (i.e retransmitting, missed acknowledgments, etc) when you receive the network error. I can give you the name of one or two if you are interested. "Jéjé" wrote: Hi, I have a custom program which create an in memory DTS package. The program works fine and has been deployed in several computers. But on 1 computer I receive a general network error when I write the table in the destination (which is SQL Server) this error appear on some tables, but not all tables. What can I do to have a better diagnostic? thanks. Jerome. |
#4
| |||
| |||
|
|
I have limited diagnostic utilities from my server. And I have no access to the client station where the DTS is started. Can I do something like an option or configuration to setup to bypass this problem? "frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote in message news:51D4AE50-28CA-4D9B-A78F-ECE20ED6902E (AT) microsoft (DOT) com... Jerome, Perhaps you could use a software packet sniffer to look at what the TCP-IP protocol is doing (i.e retransmitting, missed acknowledgments, etc) when you receive the network error. I can give you the name of one or two if you are interested. "Jéjé" wrote: Hi, I have a custom program which create an in memory DTS package. The program works fine and has been deployed in several computers. But on 1 computer I receive a general network error when I write the table in the destination (which is SQL Server) this error appear on some tables, but not all tables. What can I do to have a better diagnostic? thanks. Jerome. |
![]() |
| Thread Tools | |
| Display Modes | |
| |