dba2dba
asked on
can I use named pipe connection manager in the SSIS Connection String.
Can I specify an Explict Named Pipes connection in the Connection Manager for a Data FLow Task.
like NP:<ServerName>.
If yes, Please advice the perfromance implications of doing so,
Thanks,
like NP:<ServerName>.
If yes, Please advice the perfromance implications of doing so,
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://msdn.microsoft.com/en-us/library/system.servicemodel.netnamedpipebinding.aspx
Usually better for performance but bad for security. Stick to TCP IP.