setting DTS to use TCP/IP -- sql server (alternate)

jjone99 NO[at]SPAM hotmail.com
10/21/2003 6:52:41 AM

Hello,

I've noticed on my DTS that it is connecting to the remote SQL Server
via Named Pipes. Not sure why I've been getting the following error:
[DBNETLIB][ConnectionWrite (WrapperWrite()).] but I wanted to change
the DTS from using Named Pipes to use TCP/IP. How to do it?

Also, if anyone has any clues on what this error means, please let me
know!
Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft OLE DB Provider for SQL Server (80004005):
[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error.
Check your network documentation.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

John Bell
10/21/2003 4:12:43 PM

Hi

Check the settings in your client network utility and on the server the
server's settings

John

[quoted text, click to view]

sql server (alternate) : setting DTS to use TCP/IP