How to open SQL 2008 SSIS Packages

Karthikeyan Chinnusamy 61 Reputation points
2024-05-22T05:56:27.35+00:00

Hi All,

We have SQL 2008 R2 server with integration services and some packages, please let me know how to open the old packages and view it. What tool i need to install to view those files?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,184 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
{count} votes

Accepted answer
  1. Olaf Helper 42,746 Reputation points
    2024-05-22T06:45:05.9+00:00

    For SQL Server 2008 R2 and previous the tool to use is BIDS = "Business Intelligence Developer Studio" was used, you find the installer for the tool on SQL Server 2008 R2 installation media (DVD).

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,756 Reputation points
    2024-05-22T07:01:32.22+00:00

    Hi @Karthikeyan Chinnusamy

    You may need to use older Visual Studio to open the old package.

    If you use the newest VS tool, it will upgrade the package to the newest version, so you'd better keep the copies of the old ones.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments