Creating SSIS connection

ac_davis2002
ac_davis2002 used Ask the Experts™
on
Hi


Can i create the connections in SSIS to point to different instances of sql server? for example one connection to one instance and one connection to another?

i normally create connections using connection manager?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
BI & Reporting Analyst
Commented:
Yes, absolutely. Where you would normally specify the server name for the default instance, you would use servername\instancename for the other instances.
AnujSQL Server DBA
Top Expert 2011
Commented:

Author

Commented:
Thanks so much thats excellent

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial