Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1399
  • Last Modified:

Can BIDS 2012 deploy SIS packages to SQL Server 2008?

I have installed BIDS 2012 which I have used to create my SSIS packages.  I would like to deploy them to SQL Server 2008.  Can this be done?
0
canuckconsulting
Asked:
canuckconsulting
1 Solution
 
Sreedhar VengalaSr. Consultant - Business IntelligenceCommented:
You can't.  You must use the BIDS 2008 to develop packages for SSIS 2008.

Please see:

http://technet.microsoft.com/en-us/library/bb522577.aspx

Use the SQL Server 2005 version of Business Intelligence Development Studio to develop and maintain packages that are based on SQL Server 2005 Integration Services (SSIS).

Use the SQL Server 2008 version of Business Intelligence Development Studio to develop and maintain packages that are based on SQL Server 2008 Integration Services (SSIS)

Use SQL Server Data Tools - Business Intelligence for Visual Studio 2012 to develop and maintain packages that are based on SQL Server 2012 Integration Services (SSIS).
0
 
canuckconsultingAuthor Commented:
Thank you!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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