Solved

SSIS deployment error - SQL Server 2008 R2 / VS.NET 2008

Posted on 2014-09-28
2
451 Views
Last Modified: 2016-02-11
Hi All,
I'm having issue deploying a very simple SSIS package developed in VS.NET 2008 to SQL Server 2008 r2
I'm able to connect to integration services on 2008 R2. Created a folder and from Deployment manifest when I tried to select the same Integration server 2008r2 and package folder created to deploy, it throws up an error
I'm stuck here. Both versions are 2008.. SQL server 2008 R2 and vs.net 2008

Error : "Storing or modifying packages in sql server requires the ssis runtime and database to be the same version. Storing packages in earlier versions is not supported".

Please help
0
Comment
Question by:BI 0824
2 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40349489
Check the build version that's configured in the package. I think you developed a SSIS 2012 package and now you are trying to store it in SQL Server 2008R2.
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 40351500
Error Itself says that version of BIDS from where you developed package and where you deploying it (SQL Server) are not compatible.

Check Both are related to 2008 R2 or 2008.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

708 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

11 Experts available now in Live!

Get 1:1 Help Now