RE: How to add a server conn in business Intelligence Development Stud
- From: changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT])
- Date: Mon, 31 Mar 2008 03:49:23 GMT
Hi Betty,
I understand that you could not add a remote SQL Server instance in BIDS
when you were developing a SSIS package due to the connection error "could
not reconnect to "66" (which is part of the server IP), make sure that the
machine name and path are valid".
If I have misunderstood, please let me know.
To let me better understand your issue, could you please answer me the
following questions:
1. What is the name you input when you click "Add Server"?
2. Why would you like to add a server when you developed a SSIS package?
Generally it is not necessary, if you would like to connect to a remote SQL
Server instance in your SSIS package, you can just add a connection manager
in your SSIS project and then use the connection manager in your tasks.
Also it is no need to install BIDS on your remote server, however if you
want to deploy your SSIS package to the remote server, you have to ensure
that SSIS (SQL Server Integration Services) must be running on that server.
3. What did you want to implement in your SSIS package?
Also I would like to provide the following links for your reference:
Creating Packages in SSIS Designer
http://technet.microsoft.com/en-us/library/ms141711.aspx
Save SSIS Package (SQL Server Import and Export Wizard)
http://msdn2.microsoft.com/en-us/library/ms186943.aspx
Managing and Deploying SQL Server Integration Services
http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx
Look forward to your response. If you have any other questions or concerns,
please feel free to let me know.
Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
.
- References:
- Prev by Date: Re: question about autogrowth and shrinkfile
- Next by Date: RE: SQLCMD batch file error
- Previous by thread: RE: How to add a server conn in business Intelligence Development Stud
- Index(es):
Relevant Pages
|
Loading
