Solved

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

Posted on 2014-09-28
2
476 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 48

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

830 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