• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

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

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
BI 0824
Asked:
BI 0824
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now