Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

can I use named pipe connection manager in the SSIS Connection String.

Posted on 2010-11-23
2
Medium Priority
?
929 Views
Last Modified: 2012-06-21
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,
0
Comment
Question by:dba2dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 34201092
Read this...
http://msdn.microsoft.com/en-us/library/system.servicemodel.netnamedpipebinding.aspx

Usually better for performance but bad for security.  Stick to TCP IP.
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 2000 total points
ID: 34201118
If I recall right in ADO the connection string should be

strConnection = _T("Driver={SQL Server};Server=130.120.110.001;"
     "Address=130.120.110.001,1052;Network=dbnmpntw;Database=MyDatabaseName;"
     "Uid=myUsername;Pwd=myPassword;");

extracted from
http://www.codeproject.com/KB/database/connectionstrings.aspx

Hope this helps...
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question