Develop SSIS 2005 packages using SSIS 2008?

• sqltung

  Hall of Fame

  Points: 3962

  More actions

  January 31, 2011 at 11:20 am

  #144969

  Is it possible to develop and deploy packages targeting SQL Server 2005 from BIDS 2008 version?

• Elliott Whitlow

  SSC Guru

  Points: 102296

  More actions

  January 31, 2011 at 1:29 pm

  #1280618

  I believe the answer is no, at least I have never come up with a way to do it..

  CEWII

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  February 1, 2011 at 3:49 am

  #1280823

  sqlgreg (1/31/2011)

  ---

  Is it possible to develop and deploy packages targeting SQL Server 2005 from BIDS 2008 version?

  What do you mean with targeting?

  If you mean read out data, then yes.

  If you mean the package will run on SQL Server 2005 Integration Services, then no, as Elliot already told you.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP