2008R2 package reachability to other SQL databases

Posted on 2011-10-19
Last Modified: 2013-11-10
can SSIS 2008 R2 package be able to hit any of the following sql server databases:
sql 2000\2005\8\R2\12

from one package, can i have 5 connection strings to the above 5 versions of databases, with R2 BIDS package?
Question by:25112
    LVL 21

    Accepted Solution

    Yes...Just select "OLE DB DESTINATION", OR "SQL SERVER DESTINATION" if it's on the same box.
    LVL 3

    Assisted Solution

    Yes. Why not.
    it has backward compatibility.

    -Vinod Pottekkatt
    LVL 5

    Author Comment

    thanks for confirming.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now