Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-09-28
2
Medium Priority
?
533 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 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

963 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